simple sumif question

[psc3]

I think that this is probably straighttforward but I am very new to excel. I have been trying to use the sumif formula to count the occurance of multiple conditions. I am able to do this with two columns, but don't know how to do it with three. Basically I have three columns with different types of data in them and I want to count the number of times three conditions occur in the same row. eg if column A was colours, column B was shapes and column C was sizes, I want to count the number of times a row includes "red", "square" and "medium".

Can anyone help?

 

[cornflakegirl]

Sumif only works on one condition. You need sumproduct.

=SUMPRODUCT((A1:A10="red")*(B1:B10="square")*(C1:C10="medium")*1)

 

[psc3]

Thanks, thats great. Works a treat.

 

[Aladin Akyurek]

Sumif only works on one condition. You need sumproduct.

=SUMPRODUCT((A1:A10="red")*(B1:B10="square")*(C1:C10="medium")*1)

There is no need for the *1 bit.

 

[cornflakegirl]

Thanks Aladin

(I learned everything I know about sumproduct from you - clearly not very well! )