Forum Discussion
Solved
Multi criteria formula for SUMIFs
I have this formula which sums the agents split if the funds in general date falls between 2 dates which works fine, but I also need to add another criteria to only do this if the Client Type (in ano...
JKPieterse no it actually says 'seller' in the column in same table as agents split...see below image. So I only want it to sum the ones that say Seller but also fall between the 2 dates
What have you tried so far that did not work? Assuming the seller name is in 'Certainli CashFlow'!C4, Isn't this as simple as:
=SUMIFS(Table1[[Agents Split]:[Agents Split]],Table1[[Funds In General Date]:[Funds In General Date]],">="&'Certainli CashFlow'!C2,Table1[[Funds In General Date]:[Funds In General Date]],"<="&'Certainli CashFlow'!C3,Table1[[Client Type]:[Client Type],'Certainli CashFlow'!C4)
JKPieterse no it actually says 'seller' in the column in same table as agents split...see below image. So I only want it to sum the ones that say Seller but also fall between the 2 dates
LisaMarie1981 In that case, doesn't this work?
=SUMIFS(Table1[[Agents Split]:[Agents Split]], Table1[[Funds In General Date]:[Funds In General Date]], ">="&'Certainli CashFlow'!C2, Table1[[Funds In General Date]:[Funds In General Date]], "<="&'Certainli CashFlow'!C3, Table1[[Client Type]:[Client Type]], "Seller")- This worked! Thank you!!! Is there a way to add another word? So if it says "seller" or "landlord" it sums both?
LisaMarie1981 Sure, just do the entire SUMIFS twice, change the second one to the other category and add them up:
=SUMIFS(..."seller)+SUMIFS(..."landlord")