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!

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!

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!