Hi
Sumproduct function can also be tweaked to work for logical operations like
AND and OR
AND is represented as * and OR is represented as + in these scenarios:
http://www.bygsoftware.com/Excel/functions/sumproduct.htm
The above link will answer your queries regarding SumProduct
Regards,
Andy
On
Hi Vinu,
thanks for your post..but I don't get the Sumproduct
function..=SUMPRODUCT(($A$1:$A$9=F4)*($B$1:$B$9=G4))
what puzzles me most is (($A$1:$A$9=F4) ...I have never seen such an
expression..can you please explain it.what is the result of that
expression..
and I change the punc
Thanks a lot Vinu
That solves my problem.
Happy Ugadi to you too.
I have few more queries which I have put in the attached excel sheet. Hope
to get the answer.
Thanks in advance.
Praveen Khunte
On Sat, Mar 28, 2009 at 7:51 PM, Vinu wrote:
> Hello Praveen,
> I hope you are doing well, happy Ug
