Averageif across multiple sheets with variable content

Chantilly

New Member
Joined
Jul 15, 2019
Messages
9
Sorry, I had actually typed it wrong in my post - the code that I tried to input was dd/mm/yyyy. But as you suspected, the dates in the formula DID need to be mm/dd/yyyy...tried that and VOILA!!! Success!

Thank you so much, this has been a great help! :)
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,102,439
Messages
5,486,900
Members
407,570
Latest member
cannotquitexcel

This Week's Hot Topics

Top