Hi
=SUMIF(A1:A20,"Produce")

--
Regards
Frank Kabel
Frankfurt, Germany


proactive wrote:
Can you enter a formula in a cell that auto-inputs calculations for a
specific label?
I have a spreadsheet that documents a label in one column and within
the same row has a $ figure that pertains to that label. ex:
Produce $10.00
Meat $3.00
Dairy $8.00
I want to calculate the sum for all produce totals at the bottom of
the spreadsheet without having to select each individual cell
(A1+A5+A8) that has the word produce in the cell next to it ....