One way:
=SUMIF(A:A, "Produce", B:B)
In article ,
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 ....
|