say your data is in A1:B100. then for APAC/yes try:

=SUM(IF((A1:A100="APAC")*(B1:B100="yes");1;0))

change appropriately for Japan, no and other combinations

this is an array formula taht should be entered with CTRL+SHIFT+ENTER
instead of ENTER alone



"Julie" wrote:

Hi,

I have two sets of data that I want to summarize in another worksheet in the
same book.

Here is the exact data:

Worksheet Name: APAC_JAPAN LEARNING PARTNERS
COL A COL B
Theater Mid year
APAC Yes
APAC No
APAC No
APAC No
APAC No
APAC No
JAPAN No
JAPAN No
JAPAN No
JAPAN No
APAC No
APAC Yes
APAC Yes
APAC No
APAC No
APAC No
APAC No
APAC No
APAC Yes
APAC No
APAC Yes
APAC No
APAC No
APAC No
JAPAN No
JAPAN No
JAPAN No

Worksheet Name: Summary
Mid-Year Review Status:
APAC Japan
Yes <ins forumula here <ins forumula here
No <ins forumula here <ins forumula here

I want to place a forumla in <ins forumla here which pulls from "APAC_JAPAN
LEARNING PARTNERS" COL A (Theater) = APAC and COL (Mid Year) = Yes. I must
pull the same data for Japan, and for the "No's".

I can figure out how to edit the formula for my other needs once I get a
good formula started :).

I've been trying CountIF's, Subproducts, IF, Match, Find's, and can't seem
to figure out the right combo. I'm sure it's easy but I'm new to excel
formulas...

Thanks!
Julie