Excel help-Advice

Just wondering if you excel gurus can help me out

What I want to do is this

Need to write fomula to look up company code (AB, AC, AD etc.) and calculate totals by month (month is entered by a number in col B

If included some screen shots in word, I'm not even sure if this is possible but if you guys can give me any type of direction that would be great

Your help is very much appreciated

Try,

=SUMPRODUCT((B2:B10=1)*(C2:C10="AB")*(E2:E10))

Change the 1 and the "AB" as needed.


HTH

Steve