Sum Rows with a matching date

[teeb]

I have a s/sheet where column A has dated and columb B have monetary
values. Some of the dates in column A are the same.

What I'd like to do is look up the date in A1 and if there is any other
rows that match this date add the monetary values together.

Any help would be appreciated.

Thanks Teeb

 

[Guest]

If any date in A2:A7 = A1, then sum values in B2:B7

=SUMIF(A2:A7,"=" &A1,B2:B7)

HTH

 

[Bob Phillips]

No need for equal sign

=SUMIF(A2:A7,A1,B2:B7)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Jim May]

=Sumif(SearchRange,Criteria,ReturnRange)
=SUMIF(A1:A5,A1,B1:B5)

 

[broro183]

Hi Teeb,

two quick methods come to mind:

* type the following into cell C1 & copy down for as many rows as
needed, where "$A$1:$A$7" includes all the rows containing data.
=SUMIF($A$1:$A$7,A1,$B$1:$B$7)

*Select all your data, sort by column A (eg [alt + d + s]), and insert
subtotals (eg [alt + d + b]).

My preferred method is the first one because no data sorting is
needed.

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...