Looking formula that gives total of remaining months

  • Thread starter Thread starter AA Arens
  • Start date Start date
A

AA Arens

I am looking for the formula that calculates the total of a 12 columns representing the months, and the total is only from the next month till December.

Month: Jan Feb Mar ..... Dec Total Remaining Period
Value: M1 M2 M3 ..... M12 (Ex. Nov and Dec)

Thank you for helping me out.

Bart
Office 365
 
Hi,

Am Sat, 1 Nov 2014 18:39:45 -0700 (PDT) schrieb AA Arens:
Month: Jan Feb Mar ..... Dec Total Remaining Period
Value: M1 M2 M3 ..... M12 (Ex. Nov and Dec)
Click to expand...

try:
=SUMPRODUCT(--(COLUMN(A1:L1)>=MATCH(TEXT(TODAY(),"MMM"),A1:L1,0)),A2:L2)


Regards
Claus B.
 
I am looking for the formula that calculates the total of a 12 columns representing the months, and the total is only from the next month till December.

Month: Jan Feb Mar ..... Dec Total Remaining Period
Value: M1 M2 M3 ..... M12 (Ex. Nov and Dec)

Thank you for helping me out.

Bart
Office 365
Click to expand...

Hi Claus,

Thank you for helping me. This triggers a #N/A.
 
hi Bart,

Am Sun, 2 Nov 2014 05:52:50 -0800 (PST) schrieb AA Arens:
Thank you for helping me. This triggers a #N/A.
Click to expand...

how are your months inserted? As date with format "MMM" or as strings?
What is the range of the months and the values?


Regards
Claus B.
 
I am looking for the formula that calculates the total of a 12 columns representing the months, and the total is only from the next month till December.

Month: Jan Feb Mar ..... Dec Total Remaining Period
Value: M1 M2 M3 ..... M12 (Ex. Nov and Dec)

Thank you for helping me out.

Bart
Office 365
Click to expand...

As values, like 33, 64 etc.

Example, when it is October today, the result is "11" and all previous months are ignored:

....|Sep|Oct|Nov|Dec|Total Remaining

....| 13| 28| 4 | 7 | 11
 
Hi,

Am Sun, 2 Nov 2014 18:37:44 -0800 (PST) schrieb AA Arens:
As values, like 33, 64 etc.
...|Sep|Oct|Nov|Dec|Total Remaining
...| 13| 28| 4 | 7 | 11
Click to expand...

then try:
=SUMPRODUCT(--(MONTH(A1:L1)>MONTH(TODAY())),A2:L2)


Regards
Claus B.
 
I am looking for the formula that calculates the total of a 12 columns representing the months, and the total is only from the next month till December.

Month: Jan Feb Mar ..... Dec Total Remaining Period
Value: M1 M2 M3 ..... M12 (Ex. Nov and Dec)

Thank you for helping me out.

Bart
Office 365
Click to expand...

Thanks Claus, actually the previous version worked. I did not modify it well for my sheet. Thanks again.
 
Back
Top