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

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

No need for equal sign

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Toppers" wrote in message
...
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

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



"teeb" wrote in message
...

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

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


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