SUMPRODUCT, count & sum

T

Tasha

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!
 
T

Toppers

Is it not .....?

=SUMPRODUCT(('MTD Stats.xls'!SRV=ADMITS!$A$4)*('MTD
Stats.xls'!DISDAY=ADMITS!B$2)*('MTD Stats.xls'!DISDAYS))
 
T

Tasha

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!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top