View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mifty Mifty is offline
external usenet poster
 
Posts: 99
Default 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