close
I'm looking for a formula like quot;sumifquot; but the result of the formula is text.
If a range matches a single cell the result is text. What do I use
SUMIF usually sums values in one range dependant on values in another,
obviously you can't sum text.
are you looking to count the matches, in which case use COUNTIF or if
you're looking for one match perhaps VLOOKUP.
If you give a more specific example you can get some more specific help
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=515255
全站熱搜
留言列表
