Help Creating A Formula

[chocolab61571]

I need to create a formula that will add cells e2 through e9 if they sa
ms fuel in cells c2 through c9

Attachment filename: sample spread.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=45046

 

[rob nobel]

=SUMIF(C2:C9,"ms fuel",E2:E9) should do that for you.
(and I'll have 2 chocos please )
Rob

 

[Norman Harker]

Hi chocolab61571!

Try:
=SUMIF($C$2:$C$9,"="&"MS FUEL",$E$2:$E$9)

Or:
=SUMPRODUCT(($C$2:$C$9="MS FUEL")*($E$2:$E$9))

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.