SumIf or equivalent

[mweverett]

END GOAL to be able to add the qty for every month after the current one.

I can do it as a sumif, if I use the months numbers. Here is what I have

Months​

1​

2​

3​

4​

5​

6​

7​

8​

9​

10​

11​

12​

Qty​

1​

2​

3​

4​

5​

6​

7​

8​

9​

10​

11​

12​

50​

"=SUMIF(B1:M1,">"&MONTH(TODAY()),B2:M2)" =50 MONTH(TODAY()) being 7 for July

What I need is

January-24​

February-24​

March-24​

April-24​

May-24​

June-24​

July-24​

August-24​

September-24​

October-24​

November-24​

December-24​

1​

2​

3​

4​

5​

6​

7​

8​

9​

10​

11​

12​

0​

The dates being created by an EDATE formula such as "=EDATE("1/1/2023",12)"=January-24. I need a way to make that 0 still equal 50. I have not been able to find a way pull the month to be used in a formula.

 

[mweverett]

After I posted this, thanks to the MrExcel Forum I found the answer. I am making it harder than it has to be trying to use just the month. If I use the whole date it works. Formula =SUMIF(B4:M4,">"&TODAY(),B5:M5)

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=SUMIFS(B2:M2,B1:M1,">"&EOMONTH(TODAY(),0))