Hey all
I have a database that records the no of employees that cycle to work, but it also records the weather type.
I have build a simple chart to show the average of cyclists per week but I would like to go a step further and find a way to include weather into that, as during a rainy day the no of cyclists is lower.
Is there a way to include this in a chart of some sort.
Any help is much appreciated.
Cheers
I'm not sure how you have your chart set up, but it sounds like you're looking for the AVERAGEIFS function, which would calculate an average with certain conditions. In my sample attachment, the data is in A:C, you can enter a start date in E2, and end date in F2, and a weather type in G2. The average number of cyclists between those dates with that weather type will appear in H2 using the formula:
=AVERAGEIFS(B2:B20,A2:A20,">="&E2,A2:A20,"<="&F2,C2:C20,G2)
Take a look at the attachment; hopefully it proves helpful. If not, please provide a sample workbook using Go Advanced --> Manage Attachments so we can get a better idea of what you're working with.
If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".
If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
https://www.excelforum.com/the-water...ke-thread.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks