Specifying comparision criteria with SUMIF()

K

K_Macd

I am trying to create a sumif function that captures values where the
evaluation range is less than than a particular criteria. Excel Help provides
the following example.

Result = SUMIF(Evaluation Range,"<30",Sum Range)

This works well but rather than have a static value of 30, I wish to point
to a value in a cell ie

Result = SUMIF(Evaluation Range,"<[d1]",Sum Range)

where [d1] is a cell containing a value but I need to find the correct
specification so that the formula can be dynamic.

My scenario is actually a date comparision but once I can get a number
comparision to work I can move to the next stage.

Thanks in anticipation
 
J

Jacob Skaria

=SUMIF(C:C,"<" & E1,D:D)

OR

= SUMIF(Evaluation Range,"<" & A1,Sum Range)

If this post helps click Yes
 
S

Shane Devenshire

Hi,

If the range you are checking is the same as the one you want to sum then

=SUMIF(A:A,"<"&D1)

also you can use

=SUMIF(A:A,D1)

In which case you would enter <30 in D1. You can use this idea with the
original solution also

=SUMIF(A:A,D1,B:B)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top