Reputation: 41
I have the following excel function:
=SUM(COUNTIF($B22:$BA22,$BY$4:$BY$49))
The first range B22 - BA22 is filled with formulas that read data from other spreadsheets.
The values displayed in those cells are like "1234Pass", "3456Fail".
The values in the second range, BY4 - BY49, contain all of the possible Fail values. Those are typed in manually. All Cells are formatted as general.
The SUM formula above always displays 0 in the cell. However if I click in the formula bar and press F9, the correct value is displayed.
What am I doing wrong?
Upvotes: 0
Views: 190
Reputation: 60494
Enter the formula as an array formula -- hold down ctrl+shift
while you hit enter
. Excel will put braces {...}
around the formula if you do it correctly
Upvotes: 1