Sumifs or another sum formula

[sachavez]

Hello,

I'm stuck on writing a sumifs formula that will look at Year, Name, Dest, and Months from sum range "HVD".

I'm using names ranges:

Year = Event year
Name = Customer Name
Dest = Destination
HVD = sum range

Example, if I keyed in on Year 2022, Dest "DAYBLUFF", Month "Jan", Name "AGT SETBACK", result would = 199

Year

Name

ORIG_333

Orig St

Dest

Dest St

SMRY_EQP_TYP

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

2022​

AGT SETBACK

BIRMINGHA

AL

BIRMINGHA

AL

BVL

50​

0​

0​

0​

0​

0​

0​

0​

0​

0​

1​

0​

2022​

AGT SETBACK

BIRMINGHA

AL

DAYBLUFF

MN

BVL

110​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

10​

2022​

AGT SETBACK

BIRMINGHA

AL

DAYBLUFF

MN

TVL

89​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

1​

2022​

AGT SETBACK

CHICAGO

IL

DAYBLUFF

MN

BVL

650​

0​

0​

0​

0​

0​

0​

0​

0​

0​

0​

18​

Here's what I have so far: =sumifs(hvd,year,"2022",name,"AGT SETBACK"); HOWEVER, I am stuck on how to sum the numbers for the particular month.

Any suggestions?

Thanks, in advance

 

[Coyotex3]

What version of Excel are you using? If using 365 maybe you can maybe do something like this assuming you wanted to add up all the months

SUM(FILTER(F2:I5,(A2:A5=2022)*(B2:B5="AGT Setback")))

There is no HVD column on your sample so I just placed it next to the months. Is this something along the lines of what you are looking for? The answer is on cell A8

 

[sachavez]

What version of Excel are you using? If using 365 maybe you can maybe do something like this assuming you wanted to add up all the months

SUM(FILTER(F2:I5,(A2:A5=2022)*(B2:B5="AGT Setback")))

View attachment 106434

There is no HVD column on your sample so I just placed it next to the months. Is this something along the lines of what you are looking for? The answer is on cell A8

Thanks for the reply. HVD is the entire lookup range (Jan-Dec). I'm using 365.

 

[Coyotex3]

In that case, this formula should work. You would just have to adjust the ranges to fit your data.

=SUM(FILTER(F2:Q5,(A2:A5=2022)*(B2:B5="AGT Setback")))

 

[Fluff]

I'm using 365.

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’)

 

[sachavez]

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’)

Thanks, but I've already got "Office 365" in my signature line.

 

[Fluff]

But not in your profile, which is where most members look.