Counting multiple variables in a worksheet for summary on another
 

I am trying to sum the number of times BJ performs I&R in july, three
variables (BJ, July, I&R). I want a real number, like it happened 5 times. I
have it set up as a database so the social workers can just use the drop-down
lists in the columns. This is a text count with no numbers involved. I have a
comprehensive summary worksheet in the same workbook where I want to house
the formulas and summary functions.

Counting multiple variables in a worksheet for summary on another
 

=SUMPRODUCT(--(A2:A200="BJ"),--(Month(B2:B200)=7),--(C2:C200="I&R"))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"E.W." wrote in message
...
I am trying to sum the number of times BJ performs I&R in july, three
variables (BJ, July, I&R). I want a real number, like it happened 5 times.
I
have it set up as a database so the social workers can just use the
drop-down
lists in the columns. This is a text count with no numbers involved. I
have a
comprehensive summary worksheet in the same workbook where I want to house
the formulas and summary functions.

Counting multiple variables in a worksheet for summary on another
 

Hi Ew,

try a formula like this:

assuming that you have 3 columns and "BJ" are in column C, "July" on D and
"I$R" on E

=sumproduct(--($C$2:$c$8="BJ"),--($D$2:$D$8="July"),--($E$2:$E$8="I&R"))

Adust the range as your convinience and also you could change "BJ" and
others to a Cell to change your variables.

Hope this helps
Regards from Brazil
Marcelo


"E.W." escreveu:

I am trying to sum the number of times BJ performs I&R in july, three
variables (BJ, July, I&R). I want a real number, like it happened 5 times. I
have it set up as a database so the social workers can just use the drop-down
lists in the columns. This is a text count with no numbers involved. I have a
comprehensive summary worksheet in the same workbook where I want to house
the formulas and summary functions.