Multi Conditional SUMIF

[Martin]

Need to be able to do a SUMIF with two conditions.

1. needs to check a range of text to locate a certain
string.
2. needs to check a range of numbers (days) to check if
it is less that 7 days old

if both conditions are met, I need the SUM of both
conditions. I have tried boolean AND and function Array
{}, but still cannot get the answer.

 

[Aladin Akyurek]

It looks like you want a multiconditional count...

=SUMPRODUCT((TextTrange=TextCondtion)*(DaysRange<7))

I assumed that DaysRange houses numbers (not dates) that indicate "age" in
days.