Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to get a total count from two seperate worksheets.
ORLog sheet1 SPLog sheet2 on my summary sheet(Daily), row 2 starting with C contains the dates of the month across 1 2 3, etc. formated for d......and column B starting at B3 has abbrevation names for doctors. ORLog and SPLog have the same formats and column headers. Trying to count for each doctor, from colA(date) in both ORLog and SPLog....colE has the doctors abbreviated name in both sheets also. My formula is below and have been working on for several hours and am still getting 0's =SUMPRODUCT((ORLog!$A$2:$A$65535=C$2)*(ORLog!$E$2: $E$65535=$B2)*(SPLog!$A$2:$A$65535=C$2)*(SPLog!$E$ 2:$E$65535=$B2)) hoping someone can help me???? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumproduct for multiple sheets | Excel Worksheet Functions | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
sumproduct looking at multiple sheets | Excel Worksheet Functions | |||
Sumproduct accross multiple sheets | Excel Discussion (Misc queries) | |||
sumproduct from multiple sheets | Excel Worksheet Functions |