# SUMIF formula to get total hrs.

#### asyamonique

##### Well-known Member
 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

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

#### FDibbins

##### Well-known Member
Whats in O27?
Whats in D?
whats in J?
What did you get, why is it wrong and what did you expect

#### asyamonique

##### Well-known Member
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

#### FDibbins

##### Well-known Member
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

Replies
4
Views
956
Replies
1
Views
572
Replies
23
Views
2K
Replies
4
Views
348
Replies
2
Views
427

1,191,117
Messages
5,984,743
Members
439,906
Latest member
Sekiro1899

### 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.

### Which adblocker are you using?

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

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