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)
Click to expand...

This appears to be an Excel query, not FrontPage
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
sumif formula 1
SUMIF with criteria "<>" & "=" 4
Looping through permutations 7
Sumif does not work 2
Sum data using sumif 3
SUMIF with the criteria range 4
Sumif using partial string 7

Top