CODEWITHSUNDEEP
excelexcel-formulaexcel-2003countif
Rg786
Rg786

Reputation: 305

Counting the number of "yes" occurrences in a column where the "yes" in a different sheet is calculated from a formula

I have cell that shows the number of "Yes" present in a certain column:

=COUNTIF(Pipeline!AI$1500,"Yes")

The actual column that displays the "Yes" is derived by the formula as follows:

=IF(AH5="","",IF(AH5=0,"Yes",IF(AH5>0,"No")))

However the first formula always returns a 0, this may be a simple correction, but I would like to know how to obtain a count of "Yes" in that column which is derived by a function.

Upvotes: 0

Views: 1111

Answers (1)

AJPerez
AJPerez

Reputation: 3595

It doesn't matter if the "Yes" is derived by a function or you type it yourself. It's the same value.

Your problem seems to be the formula:

=COUNTIF(Pipeline!AI$1500,"Yes")

It's referencing only a cell (AI1500), not the whole column. To count the values in the column, change it to:

=COUNTIF(Pipeline!AI:AI,"Yes")

Upvotes: 2

Related Questions