Thread: (Urgent) If col D= value, avg col G
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
morry[_31_] morry[_31_] is offline
external usenet poster
  
Posts: 1
Default (Urgent) If col D= value, avg col G
Thank you for replying quickly.

I tried that formula but it seems like the if statement doesn't wor
because it takes the average of the entire G1:G100 range. Do you kno
how to fix this.

Thank you

Morr

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote