what if the result of a formula is text
 

I'm looking for a formula like "sumif" but the result of the formula is text.
If a range matches a single cell the result is text. What do I use

what if the result of a formula is text
 

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: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=515255