View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
karthik karthik is offline
external usenet poster
 
Posts: 48
Default Find Average using Sumproduct

Is there a way to find average based on multiple conditions.
I've been using Sumproduct formula to Sum all the cells but not sure how to
use it find average.

=SUMPRODUCT(--($B$4:$AT$4=$C$113),--($B$5:$AT$5=$C$115),$B7:$AT7)

Thanks for your help in advance...
--
Karthi