Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.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. |
#3
Posted to microsoft.public.excel.worksheet.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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Worksheet - info transfer. | New Users to Excel | |||
separate worksheet into multiple worksheets by grouping | Excel Worksheet Functions | |||
update multiple worksheet in single book | Excel Worksheet Functions | |||
Linking multiple data into one worksheet. | Excel Worksheet Functions | |||
Single worksheet, multiple pages? | Excel Discussion (Misc queries) |