I need help with a formula.....

G

Guest

I'm trying to add up cells going from left to right and what ever my answer
is.. if it's greater then (1) then I want to report just one. example. If
I'm checking somebodys work and I look at 12 diff areas, and they get 3 out
of the 12 wrong, I want to count it as one error instead of three. I've been
tring the following.
SUMIF(F11:Q11,"<0=1") all i get is 0

I hope this makes sence.

Thanks for the help
 

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

Excel Need Countifs Formula Help 0
Sumif and And formula 5
Upcoming exams need help with formulas 1
Need help with a formula 3
HELP!! New to Excel. Need complex SUMIF. 0
Help with a Formula 3
need formula help 6
need formula returning a blank cell 4

Top