Help on function in Excel

[D2C]

Hi there,

I would like to do a logical test on two colums (let's say 1 and 2), and only sum the data from colum 3 in one cell if the logical test is true for colum 1 and 2.

As I am not a frequent user of excel, I would appreciate some help!

Tnx in advance,

regards,

d2c

 

[xlbo]

You need the SUMPRODUCT formula. As an example:

=sumproduct((A2:A1000="A")*(B2:B1000="B")*(C2:C1000))

will sum all values in Col C where there is an A in col A and a B in col B. change the data ranges to match yours and you should be away

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question