Thread: SumProduct?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JimG JimG is offline
external usenet poster
 
Posts: 20
Default SumProduct?

I want to combine a SumProduct formula with a CountIF.

I want to count all occurences of "Peter" that appear in column H, if "Paul"
is in the corresponding row in column G. I am using 2007 and have tried
conditional formating but cannot make it work.

Any suggestions?