January 10th, 2010, 01:49 AM
posted to microsoft.public.excel.worksheet.functions
|
|
SumProduct not right
Hi,
I always use the asterisks - it always works
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Steve" wrote in message
news
Thank you. This works. The asterisks are also easier for me follow than
than
the dashes. I think I'll use this instead.
Are those dashes always interchangable with the asterisks in those
slightky
different positions ?
Thanks again,
Steve
"Ashish Mathur" wrote:
=SUMPRODUCT((Data!$E$3:$E$5000=$A$3)*(Data!$R$3:$R $5000=E2)*(Data!$N$3:$N$5000))
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Steve" wrote in message
...
This formula is summing ALL the incidences in the N column of what's in
E2. I
want it to sum ONLY those that are in E2 but also also matching what's
in
A3.
=SUMPRODUCT(--(Data!$E$3:$E$5000=$A$3)--(Data!$R$3:$R$5000=E2),Data!$N$3:$N$5000)
I can't figure out why it's not working, because a similiar formula
works
for other situations.
Thanks,
Steve
|