Thread: Adding column data based on match in 2nd column - Help
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GBExcel via OfficeKB.com GBExcel via OfficeKB.com is offline
external usenet poster
  
Posts: 26
Default Adding column data based on match in 2nd column - Help
No, just the number.

Thanks, your formula works perfectly. (I tried SUMIF but it didn't work. You
must have the magic touch. ;-))

GBExcel

T. Valko wrote:
Addition: 100

Does the cell actually contain the word Addition?

See if this does what you want...

=SUMIF(A10:A100,A1,B10:B100)

Hi,

[quoted text clipped - 35 lines]

GBExcel

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/201001/1

Reply With QuoteReply With Quote