ExcelBanter - Based on Data in One Column, need to SUM another

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Based on Data in One Column, need to SUM another (https://www.excelbanter.com/excel-programming/327173-based-data-one-column-need-sum-another.html)

Anne

Based on Data in One Column, need to SUM another

in I am looking for the formula syntax for the following scenario:

If any row value Column B ='CC' then SUM (E5:E55)

Can anyone assist? Many thanks!
--
Anne
Medical IT

Fredrik Wahlgren

Based on Data in One Column, need to SUM another

"Anne" wrote in message
...
in I am looking for the formula syntax for the following scenario:

If any row value Column B ='CC' then SUM (E5:E55)

Can anyone assist? Many thanks!
--
Anne
Medical IT

=SUMIF(B:B,"=CC",E5:E55)

/Fredrik

Ron Coderre[_5_]

Based on Data in One Column, need to SUM another

I'm assuming you mean any row in the Range B5:B55.
Try this:
=SUMIF(B5:B55,"CC",E5:E55)

Regards,
Ron

All times are GMT +1. The time now is 10:28 AM.