View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rene Rene is offline
external usenet poster
 
Posts: 74
Default averageif with 3 criteria

Trying to average the results of this sumproduct formula. Searched the
questions already asked but only found average if for 1 or 2 criteria

SUMPRODUCT(--(S498:S534="A"),--(G498:G534=100),--(G498:G534<=200))/SUMPRODUCT(--(S498:S534="A"),--(G498:G534<""))