sumif formula

R

Rohit

is if possible to use =sumif formula with text. I want to add data with a
text criteria.

eg =sumif(A1:A100,appple,F1:F100)
 
T

Trevor Lawrence

Rohit said:
is if possible to use =sumif formula with text. I want to add data with a
text criteria.

eg =sumif(A1:A100,appple,F1:F100)

This appears to be an Excel query, not FrontPage
 
Top