SUM based on 3 criteria but only the latest date - Excel Function

Johnny C

Well-known Member
Joined
Nov 7, 2006
Messages
1,003
Hi. the tilda is messing it up. Change ~ to ^ or some other character that will never be in your values, I tested it and it worked
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Watch MrExcel Video

Forum statistics

Threads
1,090,304
Messages
5,413,670
Members
403,496
Latest member
chamshop

This Week's Hot Topics

Top