Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with SUMPRODUCT....help please!
I am having trouble getting a count from a worksheet with multiple criteria.
Can someone look at this and see what I am doing wrong? I have two worksheets, [DAILY ADMITS WORKSHEET.xls].[dly wrksht] is the daily worksheet that changes every day, [PHYS_STATS_MTD] is the one I am putting the calculation into for each day of the month. In [PHYS_STATS_MTD], column B lists the PHYNO down(starting in cell B3) and column D lists the date of the month across starting with cell D2, however is only the number of the month. Formated to only show 'd'. Date is also set up that way in the Daily Admits worksheet. I am trying to get a count of all physicians that had admits for that day. It keeps giving me a 0. =SUMPRODUCT(('[DAILY ADMITS WORKSHEET.xls]dly wrksht'!$D$136=B3)*('[DAILY ADMITS WORKSHEET.xls]dly wrksht'!$B$2:$B$136=D2)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT #VALUE! problem | Excel Worksheet Functions | |||
Sumproduct problem | Excel Worksheet Functions | |||
SUMPRODUCT problem | Excel Worksheet Functions | |||
sumproduct problem | New Users to Excel | |||
Sumproduct Problem | Excel Worksheet Functions |