sumif criteria reference

T

TimH

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.
 
A

Aladin Akyurek

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.
 

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

Similar Threads

CountIF() & SumIF() with multiple criteria 5
Use TODAY() function as the criteria in a SUMIF formula 1
Function to Return a Date Value Q 4
IF Statement on multiple levels 6
Reconciliation... Again 1
Multi-demensional frequency distribution 4
Reference number 8
SUMIF with criteria "<>" & "=" 4

Top