SUMIF Equations

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I am trying to write a SUMIF equation that would have multiple ranges
and criterias. What I want is if the entry in B2 says "May" and a
corresponding percentage in E2 is between 7 and 8%, then I want it to
Sum the Numbers in A2. Is this possible to do?
 
Hi
not with SUMIF but use SUMPRODUCT. e.g.
=SUMPRODUCT(--(B1:B100="May"),--(E1:E100>=0.07),--(E1:E100<=0.08),A1:A1
00)
 
Don't exactly understand what you mean when you say <<"Sum the *numbers in
A2*">>.

This will look in column B for "May",
And then, if column E contains a percent between 7 and 8,
Will return the sum of numbers in matching rows from column A:

=SUMPRODUCT((B2:B100="May")*((E2:E100>=7%)-(E2:E100>8%))*A2:A100)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I am trying to write a SUMIF equation that would have multiple ranges
and criterias. What I want is if the entry in B2 says "May" and a
corresponding percentage in E2 is between 7 and 8%, then I want it to
Sum the Numbers in A2. Is this possible to do?
 
Back
Top