You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"GBExcel via OfficeKB.com" <u55438@uwe wrote in message
news:a2b294a538742@uwe...
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