Not sure what to call this

  • Thread starter Thread starter wdb
  • Start date Start date
W

wdb

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 ???
 
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
 
Back
Top