| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT, count & sum
Need help again please, and I'm going to continue searching through the posts
after asking... My current formula is: =SUMPRODUCT(('MTD Stats.xls'!SRV=ADMITS!$A$4)*('MTD Stats.xls'!DISDAY=ADMITS!B$2)) This works like a charm. Now I also need to SUM the number of discharge days from another column, in addition to these two. The defined name is DISDAYS, which summed would give me the total discharge days of all the patients with a particular service code and discharge date. Can someone help me with this? Not sure if I've given enough information, if not....just ask me... and I'll try to be more detailed. Thanks you so much! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMPRODUCT, count & sum
Is it not .....?
=SUMPRODUCT(('MTD Stats.xls'!SRV=ADMITS!$A$4)*('MTD Stats.xls'!DISDAY=ADMITS!B$2)*('MTD Stats.xls'!DISDAYS)) "Tasha" wrote: Need help again please, and I'm going to continue searching through the posts after asking... My current formula is: =SUMPRODUCT(('MTD Stats.xls'!SRV=ADMITS!$A$4)*('MTD Stats.xls'!DISDAY=ADMITS!B$2)) This works like a charm. Now I also need to SUM the number of discharge days from another column, in addition to these two. The defined name is DISDAYS, which summed would give me the total discharge days of all the patients with a particular service code and discharge date. Can someone help me with this? Not sure if I've given enough information, if not....just ask me... and I'll try to be more detailed. Thanks you so much! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMPRODUCT, count & sum
yup, that was it. I tried to sum on the end (SUM('MTD Stats.xls'!DISDAYS))
I'm not a math wiz obviously.... I will get this eventually !!! :) Thanks once again for your help!!! "Toppers" wrote: Is it not .....? =SUMPRODUCT(('MTD Stats.xls'!SRV=ADMITS!$A$4)*('MTD Stats.xls'!DISDAY=ADMITS!B$2)*('MTD Stats.xls'!DISDAYS)) "Tasha" wrote: Need help again please, and I'm going to continue searching through the posts after asking... My current formula is: =SUMPRODUCT(('MTD Stats.xls'!SRV=ADMITS!$A$4)*('MTD Stats.xls'!DISDAY=ADMITS!B$2)) This works like a charm. Now I also need to SUM the number of discharge days from another column, in addition to these two. The defined name is DISDAYS, which summed would give me the total discharge days of all the patients with a particular service code and discharge date. Can someone help me with this? Not sure if I've given enough information, if not....just ask me... and I'll try to be more detailed. Thanks you so much! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumproduct exclude count | Excel Worksheet Functions | |||
| count if or sumproduct? | Excel Discussion (Misc queries) | |||
| Count without SUMPRODUCT | Excel Worksheet Functions | |||
| SUM, COUNT and SUMPRODUCT | Excel Worksheet Functions | |||
| Count if and Sumproduct | Excel Discussion (Misc queries) | |||
Linear Mode
