J
jonnel
Hi,
I'm working on a worksheet where column A contain all the dates of thi
year (january 1 in A1, january 2 in A2, etc) an column B contains value
that I want to summate. However, I only want to summate the values i
column B from january 1 till today. The values in the other cells o
column B (corresponding to dates later in the year) should not b
summated (yet). So the summation should change automatically dail
(because the current date should now be included in the summation)
Does anybody know how I can achieve this?
Tnx,
Joh
I'm working on a worksheet where column A contain all the dates of thi
year (january 1 in A1, january 2 in A2, etc) an column B contains value
that I want to summate. However, I only want to summate the values i
column B from january 1 till today. The values in the other cells o
column B (corresponding to dates later in the year) should not b
summated (yet). So the summation should change automatically dail
(because the current date should now be included in the summation)
Does anybody know how I can achieve this?
Tnx,
Joh