Forum Discussion
Solved
Countifs producing #value
I am trying to expand a countif formula =COUNTIF(d3:d51,">0") to countifs to include a second range =COUNTIFS(D3:D51,">0", D54:D55,">0") but get the #value failure. Error checking suggests its some...
COUNTIFS(D3:D51,">0")+countifs( D54:D55,">0")
you should use + in between as the ranges are of different size, hope this helps
COUNTIFS(D3:D51,">0")+countifs( D54:D55,">0")
you should use + in between as the ranges are of different size, hope this helps
