hitch_hiker
Active Member
- Joined
- Feb 21, 2012
- Messages
- 294
I have column"A" holds sequential dates in random instances, (might be any number 1 through to 30 or even more), against each date is a value in column"B", which I need to sum. e.g. sum all for 1 july , sum all for 2 july etc. I really don't want to go through 365 filter for date then sum. Is there an easy or standard way of doing this. Note, I might need to do this across several years so the instances could easily get out of hand.
report | date | total sales | |||
2000 | 1/07/2018 | 854.25 | |||
newcastle | 1/07/2018 | 351.00 | |||
gosford | 1/07/2018 | 557.00 | 1,762.25 | =sum(c4:c6) | |
2001 | 2/07/2018 | 254.00 | |||
inv2529 | 2/07/2018 | 587.79 | |||
inv2530 | 2/07/2018 | 67.17 | |||
inv2531 | 2/07/2018 | 67.17 | |||
inv2562 | 2/07/2018 | 545.79 | |||
inv2566 | 2/07/2018 | 269.50 | |||
inv2576 | 2/07/2018 | 509.52 | 2300.94 | =sum(c7:c13) | |
2002 | 3/07/2018 | 132.04 | |||
inv2538 | 3/07/2018 | 305.14 | 437.18 | =sum(c14:c15) | |
2003 | 4/07/2018 | 215.44 | |||
inv2569 | 4/07/2018 | 112.00 | |||
2004 | 5/07/2018 | 259.85 | |||
inv2546 | 5/07/2018 | 167.93 | |||
inv2557 | 5/07/2018 | 276.52 | |||
inv2553 | 5/07/2018 | 294.00 | |||
2005 | 6/07/2018 | 290.75 | |||
inv2550 | 6/07/2018 | 374.71 | |||
inv2551 | 6/07/2018 | 191.91 | |||
inv2588 | 6/07/2018 | 454.86 |