Benders
Board Regular
- Joined
- Mar 18, 2014
- Messages
- 75
Hi
I am unable to count using using Countifs with Multiple Criteria filters and data contains Blanks/Null. Can someone please help?
I am unable to count using using Countifs with Multiple Criteria filters and data contains Blanks/Null. Can someone please help?
Fruits</SPAN> | Vendors</SPAN> | Quality</SPAN> | Fairtrade</SPAN> | |||||
Apples</SPAN> | TE</SPAN> | Low</SPAN> | Yes</SPAN> | |||||
Mangoes</SPAN> | SA</SPAN> | Medium</SPAN> | No</SPAN> | Item</SPAN> | Dropdown Selections</SPAN> | |||
Grapes</SPAN> | WA</SPAN> | High</SPAN> | Yes</SPAN> | Fruits</SPAN> | Mangoes</SPAN> | |||
Apples</SPAN> | MO</SPAN> | Low</SPAN> | No</SPAN> | Vendors</SPAN> | ||||
Mangoes</SPAN> | Medium</SPAN> | Yes</SPAN> | Quality</SPAN> | Medium</SPAN> | ||||
Grapes</SPAN> | TE</SPAN> | High</SPAN> | No</SPAN> | Fairtrade</SPAN> | Yes</SPAN> | |||
Apples</SPAN> | SA</SPAN> | Low</SPAN> | Yes</SPAN> | |||||
Mangoes</SPAN> | WA</SPAN> | Medium</SPAN> | No</SPAN> | Count = 0</SPAN> | ||||
Grapes</SPAN> | MO</SPAN> | High</SPAN> | ||||||
Apples</SPAN> | Low</SPAN> | |||||||
Mangoes</SPAN> | TE</SPAN> | Medium</SPAN> | Formula in Cell above</SPAN> |