Multiple conditions that need an "OR" function - how to do this?

**cvercrus** · 01-25-2013, 01:33 PM

I have been surfing the net for days now and desperately need help to finish this project! I've attached a copy of my Pivot table as a quick reference, but the actual data is on a different spreadsheet as shown in the formulas I've included below.

Count of JU ID Ethnic
Race HIS NHS (blank) Grand Total
AN 9 36 8 53
AS 4 125 25 154
BL 16 577 149 742
HP 3 10 2 15
WH 108 1796 465 2369
(blank) 137 64 402 603
Grand Total 277 2608 1051 3936

How can I combine the two to pick up race "AN" plus either the Ethnic "NHS" or "BLANK" depending on what was entered into the system. The "HIS" or "NHS" is suppose to be entered, however you have those who do not and it shows the field as an empty cell "BLANK". I need to be able to add the "AN" with the "NHS or BLANK" to get the total number of students who are "AN" which should equal 44.

=COUNTIFS('Census 2012'!AZ3:AZ4001,"NHS",'Census 2012'!BA3:BA4001,"AN") this does give me the 36 (indicated in pivot above)
=COUNTIFS('Census 2012'!BA2:BA4000,"AN",'Census 2012'!AZ2:AZ4000,"=") this does give me the 8 (indicated in pivot above)

Just need something that will combine and give me a total of 44

Thx in advance and your help in MOST appreciated!!!
Cris

**Moo the Dog** · 01-25-2013, 01:43 PM

Since you already have the formulas, you could just add a + in between the two formulas: =COUNTIFS(part1)+COUNTIFS(part2)

- Moo

**cvercrus** · 01-25-2013, 01:46 PM

Geewiz - I solved it! Used formula below and got the 44 that I needed.

=SUM(COUNTIFS('Census 2012'!AZ3:AZ4001,"NHS",'Census 2012'!BA3:BA4001,"AN")+ COUNTIFS('Census 2012'!BA2:BA4000,"AN",'Census 2012'!AZ2:AZ4000,"="))

**cvercrus** · 01-25-2013, 01:50 PM

Thx Moo -

As soon as I posted it, I put a couple of the formulas together "using the SUM" and entering the +; just as you had suggested but added the =sum( at the beginning.