Question 1:
try placing a quotation mark in a separate cell, all by itself, and
reference that cell in your FIND function, as:
=FIND(D16,E16) where D16 contains the quote mark and E16 contains your
data with the inches quote mark. Note that FIND only returns the
location of the character within the cell as a numeric value.
Therefore, you may need to use an IF statement to validate that FIND
returns a value, e.g.:
IF(FIND(D16,E16)0,"Do This","Not Found")
Question 2:
I am not sure why you would want to SUMIF blank cells (my guess is the
Sum is zero?), but you can use COUNTBLANK to count the number of
'blank' cells within a range. Maybe you could give an example of a
formula you are using, the results received and the expected results to
facilitate further help on this problem.
Good Luck
Bruce
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=391361