Solved How to use Multiple Condition?

July 16, 2017 at 03:54:03
Specs: Windows 10
I have 3 criteria in cell D - Name of Political Party ( Name of party is X, Y and Z, Cell E - Position ( Position is President, Secretary, Vice President and Member) and F - Ethnicity (BCTS, Dalit, OEC, RM).

I need to know how many president from Dalit ethnicity elected from Y Party?

How can I get such data from excel sheet?

See More: How to use Multiple Condition?

Report •

July 18, 2017 at 07:53:24
✔ Best Answer
When you say "cell D" I assume you mean Column D.

A cell needs both a Column and a Row reference, therefore there is no "cell D'.

Assuming that is correct, look at the COUNTIFS function:

COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)


More here:

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question