Counting data with several variables

[pugrads]

I'm hoping I explain what I'm looking to do & that someone can help me. I have attached the sample workbook for reference. I have a worksheet where data is entered (aka "LOG") & then a worksheet where the data from the "log" is summarized by date (aka "table"). I have one of each for each month of the year. What I would like to do is have formulas in the "table" that is calculated from the "log". Essentially what it is is a log of dialysis treatments at 6 different hospitals & the "table" is a summary of the items tracked along the top rows of the log.

Essentially I want the data tabluated in the following way:
1. If column A on "log" = {whatever date is in column A on table} THEN
2. If column C on "log" = {whatever word is in row 2 on table} THEN
3. Count number in each column meeting those variables.

I know there's a way to do this, but I've been out of advance excel skills for a while. Let me know if that didn't make sense or if more clarificaiton is needed!

Thanks in advance!

[rylo]

Hi

how about

'Jan Data'!L4: =SUMPRODUCT(--('Jan log'!$A$4:$A$76='Jan data'!A4),--('Jan log'!$C$4:$C$76='Jan data'!$K$2),('Jan log'!$E$4:$E$76))

This will have to be modfied for each of the ranges, etc but I think it should get you there.

rylo

[dredwolf]

Using same basic logic as rylo:pugrads.sol1.xls

did the first 3 hospitals on Jan Data tab
also added a little error correction to some of the Hrs/tx cols

Not sure I got the right columns summed on the nurse hours ones, so you may have to change the column references there

Hope this helps