Sure, you can include as many "search keys" as you like with SUMPRODUCT.
You're really only limited by to 1,024 character limit for a formula, but
even that can be overcome if you really need it.

"Rominall" wrote:

it needs to be by age as well. How many 18 year olds worked on day 1 and how
many worked on day 2 etc. Maybe I've just been looking at it too long. It
seems it should be pretty simple but I think it's fried my brain.

"JimT" wrote:

What about having a second sheet that has each status in one column, and the
next column has the "work state" in it. Then, on your rollup table, you can
just use SUMPRODUCT formulae, looking up the "worked" vs. "not worked" from
the reference column?

HTH!
-JT

"Rominall" wrote:

Okay, I have a table that lists people, their age and then their work status.
Looks like this
Name Age Day 1 Day 2 Day 3
Joe 18 Reg Stock Sick
Jill 20 Leave OnCall Reg
Mack 18 Reg OnCall Stock

Now I have a roll up table that needs to show for each day how many 18 yrs
olds worked. So it would look like this
Age Day 1 Day 2 Day 3
18 2 2 1
20 1 1 1

I've tried a countif statement but there's too many variables. There's up
to 20 status and about half are active and close to 50 ages.
I've tried a macro but I keep getting stuck with looping through the days.

How should I go about this? Help!!!!