ExcelBanter - I need to count data in one colum based on data in another column

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - I need to count data in one colum based on data in another column (https://www.excelbanter.com/excel-worksheet-functions/93745-i-need-count-data-one-colum-based-data-another-column.html)

I need to count data in one colum based on data in another column

I have 5 different data options in column M and want to count them based on a
value in column I not being N/A. I have tried sever different statements and
can not get a valid answer. The latest is: =COUNT(M4:M199="FY06
Q4",(IF(I4:I199<"N/A",1,0)))

Barb Reinhardt

I need to count data in one colum based on data in another column

Try this:

=SUMPRODUCT(--(M4:M199="FY06 Q4"),--(I4:I199<"N/A"))

"LG" wrote:

I have 5 different data options in column M and want to count them based on a
value in column I not being N/A. I have tried sever different statements and
can not get a valid answer. The latest is: =COUNT(M4:M199="FY06
Q4",(IF(I4:I199<"N/A",1,0)))

All times are GMT +1. The time now is 07:32 AM.