COUNTIF using as criteria a comparison between columns

**pnabuco** · 06-03-2013, 01:11 AM

Hi everybody,
I'm trying to use COUNTIF to determine how many cells in my worksheet shows a greater or equal value than another cell in the same line, but another column.

I have tried =COUNTIF(K:K,">="&J:J) but apparently it compares each cell in the range to a sum of the values in J:J column.

Does anybody know if it is possible to compare ranges using COUNTIF or any other function that might work for my problem?

Thanks!!!

**dilipandey** · 06-03-2013, 02:08 AM

Hi Pnabuco,

welcome to the forum.
Can you upload a sample excel workbook along with your expected results. Thanks.

Regards,
DILIPandey
<click on below * if this helps>

**bheanloh** · 06-03-2013, 03:01 AM

Formula:

Please Login or Register  to view this content.

After key in this formula press Ctrl+Shift+Enter

**pnabuco** · 06-03-2013, 05:47 AM

Thanks Boon, that is great.
Do you think I can nest that in a COUNTIFS formula? I am trying to count the cells that obey 3 different criteria. I attached the example, if you could help me.