simple sumif question

psc3

New Member
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?

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Sumif only works on one condition. You need sumproduct.

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

Thanks, thats great. Works a treat.

cornflakegirl said:
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.

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

Replies
16
Views
432
Replies
3
Views
100
Replies
4
Views
190
Replies
9
Views
173
Replies
6
Views
178

1,207,109
Messages
6,076,599
Members
446,215
Latest member
userds5593

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back