How to Countif statements with corresponding columns

[rowena229]

I have two columns (column A has colors and column B has sizes).

I need to count all the cells in column B that are a size "medium" and if the colour is "red" in column A.

What is a simple formula to calculate that.

Thank you

[FDibbins]

If you are using 2003 (as your profile says), try this....
=sumproduct((B2:B10="medium")*(A2:A10="red"))

If you have 2007 or later...
=countifs(B2:B10,"medium",A2:A10,"red")

[Max, Singapore]

You could use something like this
=sumproduct((Col A = "red")*(Col B = "medium"))
Replace Col A and Col B with the actual data ranges involved
Both ranges should be same height
-----------------------
Any good? Wave it, whack the little star at the bottom left of my responses

[rishikrsaw]

simply use countifs function as below

count ifs ( criteria range1 , criteria 1, criteria range2 , criteria 2)

pls note pls freeze criteria range

as select the range and press f4 key....

else the result would be effected if you drag ur formula down


many thanks
Rishi Saw

[rishikrsaw]

simply use countifs function as below

count ifs ( criteria range1 , criteria 1, criteria range2 , criteria 2)

pls note pls freeze criteria range

as select the range and press f4 key....

else the result would be effected if you drag ur formula down


many thanks
Rishi Saw

[Max, Singapore]

OP's version is Excel 2003 - COUNTIFS don't exist

[rishikrsaw]

so in that case we only sumproduct is only one way to solve the problem....

[Pepe Le Mokko]

so in that case we only sumproduct is only one way to solve the problem....

Yes, and both solutions were proposed in post #2 by FDibbins. So, your posts are not really useful, are they, except for making things confusing for the OP?