SUMPRODUCT, count & sum

[Guest]

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!

 

[Guest]

Is it not .....?

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

 

[Guest]

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