Countifs

[xxsalahxx]

Hello
I have three columns in a spreadhseet
Column A is text
Column B is numbers
Column C is numbers
What im trying to do is count numbers in column C is equal or over to the number in column B and is equal to certain text in column A such as apples

Not even sure if this is countif?

Can anyone help?

Thanking you in advance

 

[steve the fish]

Try this:

=SUMPRODUCT(--(A1:A100="apples"),--(C1:C100>=B1:B100))

adjust range to suit

 

[Joe4]

Try this:

=SUMPRODUCT(--(A:A="Apples"),--(C:C>=B:B))

 

[xxsalahxx]

Thank you so much

If I wanted to take this one step further and keep the sumproduct formula and only wanted count the numbers over 20 in column C do you have any idea if I can do this?
Thanks

 

[Joe4]

Its really just a matter of adding another condition similar to the two we already have there, i.e.

=SUMPRODUCT(--(A:A="Apples"),--(C:C>=B:B),[COLOR=#ff0000]--(C:C>20)[/COLOR])

You should start to see the pattern here, and should be able to add another other conditions you need.

 

[xxsalahxx]

It worked!! thank you much appreciated

 

[Joe4]

You are welcome.