| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| product key | Setting up and Configuration of Excel | |||
| need product key | Excel Discussion (Misc queries) | |||
| Sum if or sum product? | Excel Worksheet Functions | |||
| product from k= 0 to n | Excel Worksheet Functions | |||
| adding product to formula... | Excel Discussion (Misc queries) | |||
Linear Mode
