Multi Conditional SUMIF

  • Thread starter Thread starter Martin
  • Start date Start date
M

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.
 
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.
 
Back
Top