Adding or to sum product
 

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

Adding or to sum product
 

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"))



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )




"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

Adding or to sum product
 

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

Adding or to sum product
 

Thank you Arvi
--
Mifty


"Arvi Laanemets" wrote:

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"))



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )




"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

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