Adding or to sum product
Thank you Ron
--
Mifty
"Ron Coderre" wrote:
Assuming your formula got scrambled a bit when posting....
Try this:
=SUMPRODUCT(($A$2:$A$1109=F3)*($B$2:$B$1109="F")*( $C$2:$C$1109={"A","B"}))
Does that help?
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"Mifty" wrote in message
...
Hi everyone,
How do I add an or to this formula please
=SUMPRODUCT(($A$5:$A=F3)*($B$2:$B$1109="F")*($C$2: $C$1109="A"))
so that I count if Col A = number in F3 and Col B = "F" and Col C = "A" or
"B"
Many thanks
--
Mifty
|