I have a sheet for each business day on bottom of excel. I currently have formula '5.1.23:5.31.23' to calculate end of month details. How do I create the average omitting certain sheets. For example, I want the average from all 5.1.23:5.31.23. omitting sheet dated 5.22.23. This seems soo simple, but I'm not getting it, please help!
=AVERAGE(Sheet1!E3:E14)
Sheet 1 contains the data 5.1.23:5.31.23 suppose in cells E3:E14
type the equation in the sheet2 or the sheet you want to get the output.
The way I have it set up is each sheet is a specific date. I've attached a screen shot as an example. Lets say I want the average from 5.1.23 through 5.18.23, but want to exclude 5.12.23. How would I put that as a formula? Attachment 831468
Selecting Attachment 831468 results in the following message: "Invalid Attachment specified. If you followed a valid link, please notify the administrator".
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
A screenshot is not very helpful, Please post a small sample workbook. See yellow banner at the top of this page.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks