If anyone wants to try to complete test, may be to test their knowledge is free to do so.
Any Help much appreciated!
Reg
John
If anyone wants to try to complete test, may be to test their knowledge is free to do so.
Any Help much appreciated!
Reg
John
Last edited by SyedGangsta; 09-21-2013 at 08:45 PM.
This looks like a school assignment. Lookup the AVERAGEIFS function in the help.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
It would be much easier if, instead of this...
Data Range
B C 7 Monday 8 9 Darth Vader 10 Luke Skywalker 11 Princess Leia 12 Han Solo 13 Tuesday 14 15 Darth Vader 16 Luke Skywalker 17 Princess Leia 18 Han Solo
You did it like this...
Data Range
A B C 9 Monday Darth Vader 10 Monday Luke Skywalker 11 Monday Princess Leia 12 Monday Han Solo 13 14 Tuesday Darth Vader 15 Tuesday Luke Skywalker 16 Tuesday Princess Leia 17 Tuesday Han Solo
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks