Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need help with a formula.....
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 |
#2
|
|||
|
|||
=MIN(SUM(F11:Q11),1)
Vaya con Dios, Chuck, CABGx3 "photoman27" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |