Adding or to sum product

  • Thread starter Thread starter Mifty
  • Start date Start date
M

Mifty

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
 
Hi

=SUMPRODUCT(--($A$5:$A=F3),--($B$2:$B$1109="F"),--($C$2:$C$1109="A")) +
SUMPRODUCT(--($A$5:$A=F3),--($B$2:$B$1109="F"),--($C$2:$C$1109="B"))
 
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)
 
Thank you Arvi
--
Mifty


Arvi Laanemets said:
Hi

=SUMPRODUCT(--($A$5:$A=F3),--($B$2:$B$1109="F"),--($C$2:$C$1109="A")) +
SUMPRODUCT(--($A$5:$A=F3),--($B$2:$B$1109="F"),--($C$2:$C$1109="B"))
Click to expand...
 
Thank you Ron
--
Mifty


Ron Coderre said:
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)
Click to expand...
 
Back
Top