Loading spreadsheet…
Opening in Numbers for Mac...
Your browser isn’t fully supported.
For the best Numbers for iCloud experience, use a supported browser.
Learn More
Cancel
Continue
Table 1-1-1
stock
date
After tax
Month
Month name
year
vestas
8 Apr 22
2.70
4
April
2022
apple
12 Feb 21
3.92
2
February
2021
apple
13 Aug 21
4.11
8
August
2021
apple
15 May 21
4.18
5
May
2021
apple
13 Nov 20
4.01
11
November
2020
Table 2
Month/year
2020
2021
2022
2023
Total
January
0
0
0
0
0
March
0
0
0
0
0
June
0
0
0
0
0
July
0
0
0
0
0
September
0
0
0
0
0
October
0
0
0
0
0
December
0
0
0
0
0
February
0
0
0
0
0
April
0
0
0
0
0
May
0
0
0
0
0
August
0
0
0
0
0
November
0
0
0
0
0
0
0
0
0
0
The steps:
1.
The SUMIF in 'table 2' takes the reference values from the column containing Month and row containing Year.
So
fi rst step, in 'table 1-1-1', I add 3 columns (D, E and F)
2.
T
he fi rst new column (D) pulls the month number from the
date column
.
3.
The second new column
"Month Name"
(
col.
E) translates the month numbers
in column "
Month"
(column D)
into month names
in column "
Month Name"
(col E)
4.
And the third new column
"
Year
"
(
col.
F)
t
ake the year number from the
date column
5.
The values from columns E and F in 'table 1-1-1' serve as a reference for fi lling in table 2
from cells B2 to E13
.
Plus, I added a row for the total for each year.
Hope it is useful.
