Run the TrimAll macro (try Google to find it) on the F-range to remove
extraneous non-printable chars including spaces. Another way to set up
your formula is:

=SUMPRODUCT(--(DATE(YEAR(K1:K1000),MONTH(K1:K1000,1)=A102),--(F1:F1000=A105),G1:G1000)

where A102 is set to the first day date of the month/year of interest
like in: 1/1/05 (that is, the first of January 2005).

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