Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sumif criteria reference
It seems like such a simple question. Range B5:C47 is a list of dates (in
order, but some repeating) and a list of dollar amounts (deposits made on that day). I want to add up all the deposits on a given date. In column E I have a list of dates, in column F I want the sum of the corresponding date. So for example, in E5 I have the first date. In F5 I have this (which returns an error): SUMIF(B5:B47,"=E5", C5:C47). I want to return the sum of all deposits on the date in cell E5. |
#2
|
|||
|
|||
Try
=SUMIF(B5:B47,"="&E5, C5:C47) or =SUMPRODUCT(--(B5:B47=E5),C5:C47) -- Regards Roger Govier "TimH" wrote in message ... It seems like such a simple question. Range B5:C47 is a list of dates (in order, but some repeating) and a list of dollar amounts (deposits made on that day). I want to add up all the deposits on a given date. In column E I have a list of dates, in column F I want the sum of the corresponding date. So for example, in E5 I have the first date. In F5 I have this (which returns an error): SUMIF(B5:B47,"=E5", C5:C47). I want to return the sum of all deposits on the date in cell E5. |
#3
|
|||
|
|||
Not the 2nd, please.
Roger Govier wrote: Try =SUMIF(B5:B47,"="&E5, C5:C47) or =SUMPRODUCT(--(B5:B47=E5),C5:C47) |
#4
|
|||
|
|||
And why not, Aladin?
-- Regards Roger Govier "Aladin Akyurek" wrote in message ... Not the 2nd, please. Roger Govier wrote: Try =SUMIF(B5:B47,"="&E5, C5:C47) or =SUMPRODUCT(--(B5:B47=E5),C5:C47) |
#5
|
|||
|
|||
Awesome - you guys (girls?) rock!
"TimH" wrote: It seems like such a simple question. Range B5:C47 is a list of dates (in order, but some repeating) and a list of dollar amounts (deposits made on that day). I want to add up all the deposits on a given date. In column E I have a list of dates, in column F I want the sum of the corresponding date. So for example, in E5 I have the first date. In F5 I have this (which returns an error): SUMIF(B5:B47,"=E5", C5:C47). I want to return the sum of all deposits on the date in cell E5. |
#6
|
|||
|
|||
Because processing array objects takes more time than range objects.
Since SumIf does the latter and fits the task at hand (single-condition summing), a SumIf formula would be better. Roger Govier wrote: And why not, Aladin? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
SumIf Criteria Matches | Excel Worksheet Functions | |||
"criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions |