SUMIF formula to get total hrs.

asyamonique

Well-known Member
Joined
Jan 29, 2008
Messages
1,280
Office Version
  1. 2013
Platform
  1. Windows
TotalTime
122
160
183
144
645
116
90
110
86
64
178


<colgroup><col></colgroup><tbody>
</tbody>

Good Day,
I'm using that formula to populate datas like above which are the minutes
Code:
=SUMIF($D:$D,O27,$J:$J)
and simply I've added to that formula
Code:
=SUMIF($D:$D,O27,$J:$J)/60
to find total hrs. but the result was incorrect.
is there any other way to fix it?
Thanks
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Whats in O27?
Whats in D?
whats in J?
What did you get, why is it wrong and what did you expect
 
Upvote 0
Hi,

Column O
Code:
=IF(O1="","",IFERROR(SMALL($D$3:$D$400,COUNTIFS($D$3:$D$400,"<="&O1)+1),""))

Column R
Code:
=SUMIF($D:$D,O2,$J:$J)/60

Column D : ID numbers
Column J : Minutes

Thanks
 
Upvote 0
OK that was the 1st 3 questions (kind of) answered - what does O27 actually show?
You did not tell me what you got, why it was wrong and what you expected?
You have 1 column if values, and want help on a sumif() formula, that has 3 parts to it, what do the other 2 look like?

The thing is, if =SUMIF($D:$D,O27,$J:$J) worked and gives a valid number, then simply dividing that by 60 should also work
=SUMIF($D:$D,O27,$J:$J)/60
 
Upvote 0

Forum statistics

Threads
1,213,504
Messages
6,114,020
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top