sum based on content of other cells

[Gumby]

Cells A7:A49 have pull downs with 20 categories to pick from.
Cells H7:H49 has the value in hours spent on that category.
I would like to get the sum of hours based on each category, and put
this value in another cell.

Can someone please help me with this ?

Thanks

 

[Ray]

You want to use the Sumif function.

 

[Gumby]

Ray,
I have tried to use that already, but was unsuccessful.
=SUMIF(B7:B49,DESIGN,H7:H49)

I only ever get a value of 0

Any ideas ?

 

[Gumby]

*Ray,
I have tried to use that already, but was unsuccessful.
=SUMIF(B7:B49,DESIGN,H7:H49)

I only ever get a value of 0

Any ideas ? *

I got it ..... =SUMIF(B7:B49,"DESIGN",H7:H49)
was missing the quotes.


Thanks !!!