=COUNTIF(F4:H14,">0") ANSWER 12
=COUNTIF(B4:B14,AH5) ANSWER 5
But
=COUNTIFS(B4:B14,AH5,F4:H14,">0") ANSWER #VALUE!
Please help
=COUNTIF(F4:H14,">0") ANSWER 12
=COUNTIF(B4:B14,AH5) ANSWER 5
But
=COUNTIFS(B4:B14,AH5,F4:H14,">0") ANSWER #VALUE!
Please help
With COUNTIFS the ranges must be the same size. You have a one-column array (B4:B14) and a 3-column array (F4:H14), so it won't work.
You might like to try it with SUMPRODUCT.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks