software

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: www.excelforum.com/member.php...oamp;userid=13172
View this thread: www.excelforum.com/showthread...hreadid=533681If any date in A2:A7 = A1, then sum values in B2:B7

=SUMIF(A2:A7,quot;=quot; amp;A1,B2:B7)

HTH

quot;teebquot; wrote:

gt;
gt; I have a s/sheet where column A has dated and columb B have monetary
gt; values. Some of the dates in column A are the same.
gt;
gt; What I'd like to do is look up the date in A1 and if there is any other
gt; rows that match this date add the monetary values together.
gt;
gt; Any help would be appreciated.
gt;
gt; Thanks Teeb
gt;
gt;
gt; --
gt; teeb
gt; ------------------------------------------------------------------------
gt; teeb's Profile: www.excelforum.com/member.php...oamp;userid=13172
gt; View this thread: www.excelforum.com/showthread...hreadid=533681
gt;
gt;

No need for equal sign

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Toppersquot; gt; wrote in message
...
gt; If any date in A2:A7 = A1, then sum values in B2:B7
gt;
gt; =SUMIF(A2:A7,quot;=quot; amp;A1,B2:B7)
gt;
gt; HTH
gt;
gt; quot;teebquot; wrote:
gt;
gt; gt;
gt; gt; I have a s/sheet where column A has dated and columb B have monetary
gt; gt; values. Some of the dates in column A are the same.
gt; gt;
gt; gt; What I'd like to do is look up the date in A1 and if there is any other
gt; gt; rows that match this date add the monetary values together.
gt; gt;
gt; gt; Any help would be appreciated.
gt; gt;
gt; gt; Thanks Teeb
gt; gt;
gt; gt;
gt; gt; --
gt; gt; teeb
gt; gt; ------------------------------------------------------------------------
gt; gt; teeb's Profile:
www.excelforum.com/member.php...oamp;userid=13172
gt; gt; View this thread:
www.excelforum.com/showthread...hreadid=533681
gt; gt;
gt; gt;
=Sumif(SearchRange,Criteria,ReturnRange)
=SUMIF(A1:A5,A1,B1:B5)
quot;teebquot; gt; wrote in message
...
gt;
gt; I have a s/sheet where column A has dated and columb B have monetary
gt; values. Some of the dates in column A are the same.
gt;
gt; What I'd like to do is look up the date in A1 and if there is any other
gt; rows that match this date add the monetary values together.
gt;
gt; Any help would be appreciated.
gt;
gt; Thanks Teeb
gt;
gt;
gt; --
gt; teeb
gt; ------------------------------------------------------------------------
gt; teeb's Profile:
gt; www.excelforum.com/member.php...oamp;userid=13172
gt; View this thread: www.excelforum.com/showthread...hreadid=533681
gt;

Hi Teeb,

two quick methods come to mind:

* type the following into cell C1 amp; copy down for as many rows as
needed, where quot;$A$1:$A$7quot; 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 amp; the best way to learn is to experience...--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=533681