Jayded,
The formula does work, I just tried it.
Check that the text strings are the same, same spelling, no extra spaces,
etc.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Jayded542" wrote in message
...
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
|