Based on Data in One Column, need to SUM another

[Anne]

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

[Ron Coderre]

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

Regards,
Ron

[Fredrik Wahlgren]

"Anne" <[email protected]> wrote in message
news:[email protected]...
> 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