software

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

In Column quot;Aquot; I have product prices, In Column quot;Bquot; I have product codes
and in column quot;Cquot; 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 (Bamp;C) and to SUM it.

Please advice.

H.In Column quot;Aquot; I have product prices, In Column quot;Bquot; I have product codes
gt; and in column quot;Cquot; I have month values.
gt;
gt; I can't get Excel to do following:
gt;
gt; Check column C for appropriate month (example: 1) and then check column
gt; B for certain code (example: 1001) and finally to check all values in
gt; column A which match criteria (Bamp;C) and to SUM it.

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

--
Kevin Vaughnquot; wrote:

gt; I am a beginner in Excel and need help with this.
gt;
gt; gt;
gt; Please advice.
gt;
gt; H.
gt;
gt;

it kinda didn't work :unsuHi

If you have dates in column C then you would need to amend Kevin's
formula very slightly to

=sumproduct(--(month($c$2:$c$10) = 1), --($b$2:$b$10 = 1001),
($a$2:$a$10))--
Regards

Roger Govierquot;fuchkaquot; gt; wrote in message ups.com...
gt; it kinda didn't work :unsu
gt;