View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PF PF is offline
external usenet poster
 
Posts: 8
Default How to count with values from multiple columns?

I want to take the total number of "N" values from M2:M72,N2:N72 * the total
number of occurrences if value =110 (or 120,125 etc)in O2:O72,P2:P72 I also
need the count to adjust as the "n" is changed. I've tried SUMPRODUCT,
COUNTIF, IF and various combination's but I still can't get what I'm after.
Any help would be much appreciated.

Patrick