Thread: Trying to get an IF/AND average to work
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sage
 
Posts: n/a
Default Trying to get an IF/AND average to work
One more question if you're still around. How would I only average cells in
column F that contain information and ignore blank cells? As of now it's
bring my average down if there's a cell with nothing in it.

=AVERAGE(IF(Period Data!A1:A200="January",IF(Period Data!E1:E200=2005,Period
Data!F1:F200,FALSE)))

Thanks again!

Sage
Reply With QuoteReply With Quote