In Column "A" I have product prices, In Column "B" I have product codes
and in column "C" I have month values.

I can't get Excel to do following:

Check column C for appropriate month (example: 1) and then check column
B for certain code (example: 1001) and finally to check all values in
column A which match criteria (B&C) and to SUM it.

try something like: =sumproduct(--($c$2:$c$10 = 1), --($b$2:$b$10 = 1001),
($a$2:$a$10))

--
Kevin Vaughn


" wrote:

I am a beginner in Excel and need help with this.


Please advice.

H.