Thanks to everyone that helped me! This made my life so much easier!!
Jana

"Jayded542" wrote:

I have used the previous posts here to answer most of my questions today, but
was just advised I need to add another variable into my formula... I've tried
to adjust it and it doesn't work and I'm now at a loss.. Can someone help!?

Currently I have:
=SUMPRODUCT(--(K1:K1000=A102),--(K1:K1000<=A103),--(F1:F1000=A105),G1:G1000)

Column K contains different dates
Column G contains a random number between 1 and 1000 (the # of participants)
Column F contains one of six different options (Teambuilding, Coaching...
etc) (picked from a Validated List)
A102 is January 1/05
A103 is January 31/05
A105 contains the word 'Teambuilding'


The answer comes out to be "0"
My original formula worked, but I didn't include "--(F1:F1000=A105)". This
is the extra variable I need to count by.

Also, ultimately, I would like these formulas to calculate in another
worksheet altogether, but that is way above my head! Can all this actually
happen in the same formula??

Thanks!
Jayded