sum based on content of other cells

G

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
 
G

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 ?
 
G

Gumby

Gumby said:
*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 ? *
Click to expand...


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


Thanks !!!
 
Top