Looking formula that gives total of remaining months

[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

 

[Claus Busch]

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)

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


Regards
Claus B.

 

[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 Claus,

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

 

[Claus Busch]

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.

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.

 

[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

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

 

[Claus Busch]

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

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


Regards
Claus B.

 

[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

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