Hello,

Heres my relatively simple problem:

A B
Qty @
1.0 DAYS
1.0 DAYS
1.0 DAYS
1.0 DAYS
1.0 DAYS
1.0 DAYS
5.0 HRS
8.0 HRS
10.0 HRS
1.0 DAYS
1.0 DAYS
1.0 DAYS
1.0 DAYS
1.0 DAYS
10.0 HRS
8.0 HRS




I have two columns one that signifies days and one that signifies hours.

I want a formula to sum the days and the hours separately depending on what the corresponding row says.

ie:
DAYS = 34
HRS = 46

I was thinking a SUMIF formula was the one to use...

thanks