Two columns (Hours/ Days) (Quantity) Want to sum the hours/ and days

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

Try this:

=SUMIF(B:B,"DAYS",A:A)

and:

=SUMIF(B:B,"HRS",A:A)

Hope this helps.

Pete

Yes it did... Thank you very much!