MrFoxar
07-08-2007, 02:52 PM
Hi there,
Just trying to figure out how to get SUMIF to look at only part of string of text in criteria.
example:
I have several transaction ID's in a range of cells, each type indicated by a prefix. Like, DNHT724672, DNHT239904, WYER8345.
Is there a way I can get SUMIF to only look at a portion of the cell, in this case the first four characters?
I just can't wrap my brain around what the syntax would be, even if it is possible. :banghead:
Thanks
Just trying to figure out how to get SUMIF to look at only part of string of text in criteria.
example:
I have several transaction ID's in a range of cells, each type indicated by a prefix. Like, DNHT724672, DNHT239904, WYER8345.
Is there a way I can get SUMIF to only look at a portion of the cell, in this case the first four characters?
I just can't wrap my brain around what the syntax would be, even if it is possible. :banghead:
Thanks