Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Specifying comparision criteria with SUMIF()
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 -- Ken "Started using Visicalc in 82" |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Specifying comparision criteria with SUMIF()
=SUMIF(C:C,"<" & E1,D:D)
OR = SUMIF(Evaluation Range,"<" & A1,Sum Range) If this post helps click Yes --------------- Jacob Skaria "K_Macd" wrote: 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 -- Ken "Started using Visicalc in 82" |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Specifying comparision criteria with SUMIF()
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) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "K_Macd" wrote: 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 -- Ken "Started using Visicalc in 82" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dates comparision | New Users to Excel | |||
date range comparision on a criteria | Excel Discussion (Misc queries) | |||
text comparision | Excel Discussion (Misc queries) | |||
Comparision formula | New Users to Excel | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions |