what if the result of a formula is text

H

HB

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
 
D

daddylonglegs

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
:)
 
Top