Thread
:
Help with if and looping
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Help with if and looping
You need to define your "worked" criteria. I can see that "sick" is not
worked. Is "oncall" worked???
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Rominall" wrote in message
...
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!!!!
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett