countif issue

[Aberdham]

Hi guys,

I would like to count the number of person whose profit is greater than 20% of their base, I use countif(C2:C10;"<20%") but it doesn't produce the result that I want.

can somebody please advise?

thank you in advance.

 

[Phuoc]

Try this:

=SUMPRODUCT(--(B2:B10*0.2<C2:C10))

 

[Aberdham]

Try this:

=SUMPRODUCT(--(B2:B10*0.2<C2:C10))

ah that's great thanks. any chance of using a countif function to make it work?

 

[Phuoc]

The COUNTIF function can't solve it.

 

[Alex Blakenburg]

ah that's great thanks. any chance of using a countif function to make it work?

To use countif you would need a helper column that has pre-calculated the % value.
Without that you need an array formula such as sumproduct or the old style array using Ctrl+Shift+Enter or if you have 365 you have more options.

PS: you might want to update your profile to show what version you are using.