Hi,
I have several worksheets that are all formatted exactly the same and then one worksheet at the back with various kinds of summary and total data.
An example spreadsheet is attached.
Each worksheet, except the summary one, represents the sales and costs of an individual store from January through July 2013.
In the Summary worksheet I'm trying to get the average sales and costs for the stores.
I'm using the "averageif" function because one of the stores is closed down during the year and has $0 sales. I'd like to ignore these.
I can't get the "averageif" to work -- I keep getting "value". Please see specifically the yellow shaded cells in the "Summary" tab attached.
Thanks.
Bookmarks