SUMIFS: Two Dates/Criteria/Cost Column

[Morey]

I'm looking to modify the countif formula below to sumif. The only difference is the addition of the the cost column ('Activity'!I:I). Any help would be appreciated.


=COUNTIFS('Activity'!B:B,"WA1F&G",'Activity'!G:G,">="&A16,'Activity'!G:G,"<="&B16)



Thanks in advance,


Morey

 

[Morey]

I'm looking to modify the countif formula below to sumif. The only difference is the addition of the the cost column ('Activity'!I:I). Any help would be appreciated.


=COUNTIFS('Activity'!B:B,"WA1F&G",'Activity'!G:G,">="&A16,'Activity'!G:G,"<="&B16)



Thanks in advance,


Morey

Figured it out...

=SUMIFS('WMS Activity'!I:I,'WMS Activity'!B:B,"WA1F&G",'WMS Activity'!G:G,">="&A16,'WMS Activity'!G:G,"<="&B16)


Morey