Thread
:
Adding or to sum product
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Mifty
external usenet poster
Posts: 99
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
Reply With Quote
Mifty
View Public Profile
Find all posts by Mifty