Steve 1962
Active Member
- Joined
- Jan 3, 2006
- Messages
- 353
- Office Version
- 365
- Platform
- Windows
Hi
I would like to have formulas in columns K, L, M & N that summarise the various categories from the source data located in columns A to E and H.
There are two main headings in columns K to N (Black & Red) which both have two sub-categories (Kgs & Fee).
Each row in columns K to N are summarising by each day.
Thanks
I would like to have formulas in columns K, L, M & N that summarise the various categories from the source data located in columns A to E and H.
There are two main headings in columns K to N (Black & Red) which both have two sub-categories (Kgs & Fee).
Each row in columns K to N are summarising by each day.
Thanks
Book1 | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |||
1 | Date | Month | Car | Goods | Kgs | Fee1 | Fee2 | Fee -Total | Summary | Black - Kgs | Black - Fee | Red - Kgs | Red - Fee | |||
2 | 1/07/2019 | 1/07/2019 | Black | Apples | 0 | 0 | 1/07/2019 | 65 | 563 | 25 | 57 | |||||
3 | 1/07/2019 | 1/07/2019 | Black | Oranges | 0 | 0 | 2/07/2019 | 220 | 53 | 129 | 168 | |||||
4 | 1/07/2019 | 1/07/2019 | Black | Bananas | 50 | 23 | 14 | 37 | 3/07/2019 | 816 | 840 | 52 | 263 | |||
5 | 1/07/2019 | 1/07/2019 | Black | Oranges | 0 | 0 | 4/07/2019 | |||||||||
6 | 1/07/2019 | 1/07/2019 | Black | Grapes | 5 | 11 | 65 | 76 | 5/07/2019 | |||||||
7 | 1/07/2019 | 1/07/2019 | Red | Carrots | 15 | 22 | 15 | 37 | 6/07/2019 | |||||||
8 | 1/07/2019 | 1/07/2019 | Black | Mango | 0 | 0 | 7/07/2019 | |||||||||
9 | 1/07/2019 | 1/07/2019 | Black | Nuts | 10 | 150 | 300 | 450 | 8/07/2019 | |||||||
10 | 1/07/2019 | 1/07/2019 | Black | Tomato | 0 | 0 | 9/07/2019 | |||||||||
11 | 1/07/2019 | 1/07/2019 | Red | Onion | 10 | 5 | 15 | 20 | 10/07/2019 | |||||||
12 | 2/07/2019 | 1/07/2019 | Black | Apples | 0 | 0 | 11/07/2019 | |||||||||
13 | 2/07/2019 | 1/07/2019 | Black | Oranges | 0 | 0 | 12/07/2019 | |||||||||
14 | 2/07/2019 | 1/07/2019 | Black | Bananas | 0 | 0 | 13/07/2019 | |||||||||
15 | 2/07/2019 | 1/07/2019 | Red | Oranges | 26 | 55 | 41 | 96 | 14/07/2019 | |||||||
16 | 2/07/2019 | 1/07/2019 | Red | Grapes | 15 | 11 | 14 | 25 | 15/07/2019 | |||||||
17 | 2/07/2019 | 1/07/2019 | Black | Carrots | 220 | 35 | 18 | 53 | 16/07/2019 | |||||||
18 | 2/07/2019 | 1/07/2019 | Black | Mango | 0 | 0 | 17/07/2019 | |||||||||
19 | 2/07/2019 | 1/07/2019 | Black | Nuts | 0 | 0 | 18/07/2019 | |||||||||
20 | 2/07/2019 | 1/07/2019 | Red | Tomato | 62 | 15 | 14 | 29 | 19/07/2019 | |||||||
21 | 2/07/2019 | 1/07/2019 | Red | Onion | 26 | 13 | 5 | 18 | 20/07/2019 | |||||||
22 | 3/07/2019 | 1/07/2019 | Red | Apples | 15 | 24 | 14 | 38 | 21/07/2019 | |||||||
23 | 3/07/2019 | 1/07/2019 | Red | Oranges | 5 | 25 | 26 | 51 | 22/07/2019 | |||||||
24 | 3/07/2019 | 1/07/2019 | Red | Bananas | 6 | 1 | 58 | 59 | 23/07/2019 | |||||||
25 | 3/07/2019 | 1/07/2019 | Black | Oranges | 0 | 0 | 24/07/2019 | |||||||||
26 | 3/07/2019 | 1/07/2019 | Black | Grapes | 816 | 225 | 615 | 840 | 25/07/2019 | |||||||
27 | 3/07/2019 | 1/07/2019 | Red | Carrots | 5 | 16 | 21 | 37 | 26/07/2019 | |||||||
28 | 3/07/2019 | 1/07/2019 | Red | Mango | 6 | 25 | 14 | 39 | 27/07/2019 | |||||||
29 | 3/07/2019 | 1/07/2019 | Red | Nuts | 15 | 24 | 15 | 39 | 28/07/2019 | |||||||
30 | 3/07/2019 | 1/07/2019 | Black | Tomato | 0 | 0 | 29/07/2019 | |||||||||
31 | 3/07/2019 | 1/07/2019 | Black | Onion | 0 | 0 | 30/07/2019 | |||||||||
Sheet2 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2:B31 | B2 | =A2-DAY(A2)+1 |
D12:D31 | D12 | =D2 |
H2:H31 | H2 | =F2+G2 |