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

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

HTH

"teeb" wrote:


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


--
teeb
------------------------------------------------------------------------
teeb's Profile: http://www.excelforum.com/member.php...o&userid=13172
View this thread: http://www.excelforum.com/showthread...hreadid=533681