|
|
Sumif criteria greater than or less than another cell
SUMIF(A1:A10,>B5,C1:C10)
You can see what I'm trying to do. How do I do it?
|
|
0
|
|
|
|
Reply
|
 Utf
|
1/6/2010 7:02:01 AM |
|
maybe this is what you want
=SUMPRODUCT((A1:A10>B5)*(C1:C10))
--
Gary Keramidas
Excel 2003
"Don O" <Don O@discussions.microsoft.com> wrote in message
news:7AD567CD-0A78-4522-8A24-DFC24E4DC786@microsoft.com...
> SUMIF(A1:A10,>B5,C1:C10)
>
> You can see what I'm trying to do. How do I do it?
|
|
|
0
|
|
|
|
Reply
|
Gary
|
1/6/2010 7:08:41 AM
|
|
Try
=SUMIF(A1:A10,">" & B5,C1:C10)
Since B5 is a cell reference you need to combine the text string ">" with
the cell reference using &
--
Jacob
"Don O" wrote:
> SUMIF(A1:A10,>B5,C1:C10)
>
> You can see what I'm trying to do. How do I do it?
|
|
|
0
|
|
|
|
Reply
|
Utf
|
1/6/2010 7:14:01 AM
|
|
maybe this is what you want
=SUMPRODUCT((A1:A10>B5)*(C1:C10))
"Don O" wrote:
> SUMIF(A1:A10,>B5,C1:C10)
>
> You can see what I'm trying to do. How do I do it?
|
|
|
0
|
|
|
|
Reply
|
Utf
|
1/6/2010 7:18:01 AM
|
|
|
3 Replies
906 Views
(page loaded in 0.084 seconds)
Similiar Articles: Sumif criteria greater than or less than another cell - microsoft ...SUMIF(A1:A10,>B5,C1:C10) You can see what I'm trying to do. How do I do it? ... Sumif number is greater than a number but less than another number ...Sumif number is greater than a number but less than another number ... than a ... Sumifs, greater than and less than in 1 ... Yes, just add another criteria to the SUMIFS ... Sumif comparing dates in criteria - microsoft.public.excel.misc ...SUMIF can only have one criteria, but you're looking to use two (less than or equal, greater than). ... to make the condition refer to another cell ... Using SUMIFS with date range - microsoft.public.excel.misc ...... is greater than or equal to a beginning date entered into a specific cell and 3. is less than or equal to an end date entered into another ... range criteria in SUMIF ... multiply criteria in a range using sumifs - microsoft.public.excel ...Sumif number is greater than a number but less than another number ... multiply criteria in ... SUMIF, use List as a Range - microsoft.public.excel.misc ... In another cell I ... Modify SUMIF to find data range in addition to value - microsoft ...... be greater > than or equal to one value and lesser than or equal to another, and match > the > value in D1 to sumif ... sumif based on a criteria in ... than ... the cell ... Sumif using Values, but returning text or values - microsoft ...Sumif number is greater than a number but less than another number ... ... blank cells in another column (range) using SUMIF(A ... is this criteria ... return another cell ... SUMIF non-blank cells? - microsoft.public.excel.newusers ...... on the blank cells in another column (range) using SUMIF ... are subtracting the sumif result, for the blank cell criteria ... like to understand better how this criteria ... SUMIF, use List as a Range - microsoft.public.excel.misc ...In another cell I want to use the SUMIF function, and as a range use the ... Sum_Range: D2:D875 Criteria Need: ????? Sum if the number in A is greater than 4000 ... sum ... Countif and values greater than zero for a named range - microsoft ...Sumif number is greater than a number but less than another number ... ... COUNTIF(range, criteria) ... cell range or a named range. ... contain a number greater than 40. Sumif criteria greater than or less than another cell ExcelTry =SUMIF(A1:A10,">" & B5,C1:C10) Since B5 is a cell reference you need to combine the text string ">" with the cell reference using & -- Jacob Sumif criteria greater than or less than another cellPosted: Tue Jan 05, 2010 11:02 pm Post subject: Sumif criteria greater than or less than another cell Archived from groups: microsoft>public>excel>misc ... Sumif criteria greater than or less than another cell - ExcelBanterExcel Discussion (Misc queries) ... SUMIF(A1:A10,>B5,C1:C10) You can see what I'm trying to do. How do I do it? ... maybe this is what you want =SUMPRODUCT((A1:A10>B5 ... Sumif criteria greater than or less than another cell - microsoft ...SUMIF(A1:A10,>B5,C1:C10) You can see what I'm trying to do. How do I do it? ... SumIf Based on 2 Conditions in Excel - Excel Conditional Sum ...The SumIf formula is not far behind in complexity. ... can see that you could have chosen equal, less than, greater ... With the second choice, Excel will set up a new cell ... 7/18/2012 8:42:00 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
66 followers. 