Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Not sure what to call this
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Not sure what to call this
look in the help index for SUMIF
-- Don Guillett Microsoft MVP Excel SalesAid Software "wdb" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Not sure what to call this
Maybe this:
http://www.contextures.com/xlFunctions01.html#Exact Or this: http://www.contextures.com/xlFunctio...tml#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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Not sure what to call this
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 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 ??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not sure what to call this | Excel Programming | |||
call C++ DLL from VBA | Excel Programming | |||
How to call this DLL? | Excel Programming | |||
Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
Don't know what to call what I need? | Excel Worksheet Functions |