Prev: How to display a macro generated menu in Excel 2007
Next: VBA Workbook Open Function
From: wdb on 19 May 2010 15:16
Basically i want to set up a formula to add up cells in one column with a
certain name in another column, so i can keep track of how much i am spending
with that supplier. Is this a IF formula ???
--
thanks in advance, wdb
From: Don Guillett on 19 May 2010 15:20
look in the help index for SUMIF
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"wdb" <wdb(a)discussions.microsoft.com> wrote in message
news:4AD44B47-1477-49A2-BDF0-1B1DB927F103(a)microsoft.com...
> Basically i want to set up a formula to add up cells in one column with a
> certain name in another column, so i can keep track of how much i am
> spending
> with that supplier. Is this a IF formula ???
> --
> thanks in advance, wdb

From: ryguy7272 on 19 May 2010 15:34
Maybe this:
http://www.contextures.com/xlFunctions01.html#Exact

Or this:
http://www.contextures.com/xlFunctions01.html#SumProduct

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"wdb" wrote:

> Basically i want to set up a formula to add up cells in one column with a
> certain name in another column, so i can keep track of how much i am spending
> with that supplier. Is this a IF formula ???
> --
> thanks in advance, wdb
From: Chip Pearson on 19 May 2010 16:06
Try the SUMIF function. E.g.,

=SUMIF(A1:A100,"word",B1:B100)

where A1:A100 is your list of suppliers, "word" (with the quotes) is
the name of the supplier you are interested in, and B1:B100 are the
dollar amounts. The formula will sum the values in B1:B100 where the
corresponding cell in A1:A100 is "word".

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com


On Wed, 19 May 2010 12:16:06 -0700, wdb
<wdb(a)discussions.microsoft.com> wrote:

>Basically i want to set up a formula to add up cells in one column with a
>certain name in another column, so i can keep track of how much i am spending
>with that supplier. Is this a IF formula ???
 | 
Pages: 1
Prev: How to display a macro generated menu in Excel 2007
Next: VBA Workbook Open Function