Thread: Formula to figure an average on a range of cells with an "if" form
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
J Sedoff comRemove> J Sedoff comRemove> is offline
external usenet poster
  
Posts: 42
Default Formula to figure an average on a range of cells with an "if" form
Do you mean like average()?

=Average(G1:G5)

Hope this helps, Jim
--
I appreciate any feedback.


"lucyo912" wrote:

I have a spreadsheet that has a formula in column g that is an "if" formula
for the data in column f. I need to get an average of the data in column
"g". For example

column f column g
yellow 2
green 3
red 1
red 1
red 1
average yellow need formula for this

help!
Reply With QuoteReply With Quote