So another Excel question pops up on CP! Any help would be greatly appreciated. I have this formula:
=COUNTIFS(RAW_DATA!D:D,{"Yellow","Brown","Green"}, RAW_DATA!G:G,"<15000",RAW_DATA!P:P,{"Apple","Pear" ,"Cherry"})
This formula creates no errors so it appears to be working. I want to count the rows that have yellow, brown or green in column D, below 15000 in column G (including zeros) and is also an apple, pear or cherry in column P. However the calculation is not accurate. This formula will generate say a count of 415. But if I go into the sheet and use Filters and manually count, I get 625. Any ideas?
|