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?
<TBODY>
</TBODY><COLGROUP><COL span=2><COL span=2><COL><COL><COL><COL><COL></COLGROUP>
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> | |||||
Grapes</SPAN> | SA</SPAN> | High</SPAN> | No</SPAN> | =COUNTIFS(A2:A16,G4,B2:B16,G5,C2:C16,G6,D2:D16,G7)</SPAN> | ||||
Apples</SPAN> | WA</SPAN> | Low</SPAN> | Yes</SPAN> | |||||
Mangoes</SPAN> | MO</SPAN> | Medium</SPAN> | No</SPAN> | |||||
Grapes</SPAN> | High</SPAN> | Yes</SPAN> | ||||||
<TBODY>
</TBODY><COLGROUP><COL span=2><COL span=2><COL><COL><COL><COL><COL></COLGROUP>