Sum Multiple Columns based on Month (Need Formula)

**bd827** · 10-23-2019, 10:13 AM

Hi, all!

I am looking for a formula that can add different dollar totals together based on the months that they are due. Based on the attached sample, I would like to add columns C, E, F, G, I, J, and K together depending on the date in columns B, D and H and put the information into a column for that specific month.

I would like a formulas for columns L, M and N that say if the month in columns B, D or H is (Month) then add columns C, E, F, G, I, J and K. The caveat to this is that were are different months for the same SKU so the formula needs to add only the columns to the right of the correct month.

I know I am not wording this correctly. Please see the attached example for better information.

Thanks!!

**63falcondude** · 10-23-2019, 10:28 AM

Hello and welcome to the forum.

Change L3:O3 to 9/1/2019 through 12/1/2019 (you can format these however you'd like).

Then you can use this in L4:

=IF(EOMONTH($B4,-1)+1=L$3,$C4,0)+IFERROR(IF(EOMONTH($D4,-1)+1=L$3,SUM($E4:$G4),0),0)+IF(EOMONTH($H4,-1)+1=L$3,SUM($I4:$K4),0)

Drag to the right and down.

**bd827** · 10-23-2019, 10:32 AM

Hi and thanks for the quick response!

For clarification, where/how in the formula do I reference the month? In your example, how would I show that I only want info for the month of September?

Thanks, again.

**63falcondude** · 10-23-2019, 10:40 AM

The references to the dates are highlighted in blue. The references to the months are highlighted in red.

=IF(EOMONTH($B4,-1)+1=L$3,$C4,0)+IFERROR(IF(EOMONTH($D4,-1)+1=L$3,SUM($E4:$G4),0),0)+IF(EOMONTH($H4,-1)+1=L$3,SUM($I4:$K4),0)

Make sure that you change L3:O3 to actual dates as mentioned in post #2.

**bd827** · 10-23-2019, 10:58 AM

This is perfect!!! I had changed the dates in L2:O2 instead of L3:O3.

Thanks so much!

**63falcondude** · 10-23-2019, 11:48 AM

You're welcome. Happy to help.

Sum Multiple Columns based on Month (Need Formula)

LinkBack

Thread Tools

Rate This Thread

Display

Sum Multiple Columns based on Month (Need Formula)

Re: Sum Multiple Columns based on Month (Need Formula)

Re: Sum Multiple Columns based on Month (Need Formula)

Re: Sum Multiple Columns based on Month (Need Formula)

Re: Sum Multiple Columns based on Month (Need Formula)

Re: Sum Multiple Columns based on Month (Need Formula)

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula for Weighted Averages Based on Multiple Columns? Array Formula?

Sum multiple columns based on month header

[SOLVED] date formula that puts the first of the prior month based on which month it is

[SOLVED] Averaging Multiple columns based on Weeknum compared to Month

[SOLVED] Formula for amount on previous month based on current month

Formula for average duration for each month based on the ending month

Formula to return day based on month end date & day number of month

Bookmarks

Bookmarks

Posting Permissions