Analyzing multiple cells and reporting values.

[DANNYB667]

Ok i need help with a formula. I am analyzing column C. every time the text "2.5" appears in C I need to report the value of the corresponding cell from column D. Example : c26 and c39 have the text "2.5" in them, so I need to add up the total of cells D26 and D39.

 

[Joe4]

Use the SUMIF formula, i.e.

=SUMIF(C1:C100,"2.5",D1:D100)

See: MS Excel: How to use the SUMIF Function (WS)

 

[mumps]

Place this formula in a cell where you want your sum to appear: =SUMIF(C2:C50,"=2.5",D2:D50) Change the ranges to suit your needs.