SUMIFS w/Multiple Conditions Duplicating Responses

[CaroleAnn]

Hi everyone, first time poster here. Struggling with a giant spreadsheet of data and can really use your help! Have to sum the totals of 6 rows of 6 different service types, by columns to separate each month, and each month is separated by those with "active" statuses from all other statuses. Thought I was golden last night but results have given me the same figures for "active" VS all other statuses for each individual month. (hope this makes sense). This was my best swing at this:

For March 2021, Service type "Digital" with a status of "active":

=SUMIFS('All Projects '!T3:T11000,'All Projects '!D3:D11000,"=*SEO*",'All Projects '!C3:C11000,">=01/01/2021",'All Projects '!C3:C11000,"<=01/31/2021")*AND(SUMIFS('All Projects '!T3:T11000,'All Projects '!K3:K11000,"=active"))

For March 2021, Service type "Digital" with a status of anything but "active":

=SUMIFS('All Projects '!T3:T11000,'All Projects '!D3:D11000,"=*SEO*",'All Projects '!C3:C11000,">=01/01/2021",'All Projects '!C3:C11000,"<=01/31/2021")*AND(SUMIFS('All Projects '!T3:T11000,'All Projects '!K3:K11000,"<>active"))

Any insight would be greatly appreciated!

 

[Fluff]

Hi & welcome to MrExcel.
Not sure what you are trying to do, but how about

=SUMIFS('All Projects '!T3:T11000,'All Projects '!D3:D11000,"=*SEO*",'All Projects '!C3:C11000,">=01/01/2021",'All Projects '!C3:C11000,"<=01/31/2021",'All Projects '!K3:K11000,"=active")

 

[CaroleAnn]

A snip of the results I received...

 

[Fluff]

Did the formula I suggested work?

 

[CaroleAnn]

OMG Fluff!! Thank you! Yes that worked!!
Whew!!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[CaroleAnn]

Hi there, me again! So I haven't been able to reconcile the totals on my sheet. The total of the formulated cells is considerably higher that expected and I believe it is in relation to the date ranges - perhaps an overlapping. Need each cell to cover the days of each month. Currently have ">=01/01/2021" to "<=01/31/2021"

 

[Fluff]

That formula should sum all values in col T where col D contains SEO, col C is January 21 & col K is Active.

 

[CaroleAnn]

Hmmm.. So as I mentioned in the initial post, I have two columns, one for active and one for all other statuses. The total of the data base is about $189K less than the total of the formulated summaries.
I copied the formula you provided for the non-active items and changed it to "<>active"

 

[Fluff]

Without seeing your data, there is not much I can do.