It sounds like you need the references shifted slightly, to account for added
column?

=IF(ISERROR(MATCH(E1,A:A,0)),"Does not
exist",IF(F1=SUMIF(A:A,D1,C:C),"=",IF(F1SUMIF(A:A ,D1,C:C),""&F1-SUMIF(A:A,D1,C:C),"<"&F1-SUMIF(A:A,D1,C:C))))

Note that if the range references are still slightly off, you can adjust
them fairly easily.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"out0015" wrote:

ALSO IF YOU COULD PLEASE SHOW THE AMOUNT OF OVERAGE AND UNDERAGE IE 2, OR
<3.
ALSO IF YOU COULD ADD A COLUMN OF NON PARTICIPATING SCHOOL MEANING COLUMN E
DOESNT EXIST IN COLUMN A.

I APPRECIATE YOUR HELP

"out0015" wrote:

It looks fine but I missed 1 column , a column between D and E that is for
the name of the schools (same name as column B)
pLease advise.

thanks

"Luke M" wrote:

Thanks for clearing it up. Assuming your data starts in row 1:

=IF(E1=SUMIF(A:A,D1,C:C),"=",IF(E1SUMIF(A:A,D1,C: C),"","<"))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"out0015" wrote:

I tried to post it clearly but the screen could only fit so much.
The last column F is the < = column that i want to input automatically
when i manually input column E. the 6781 in column D is less than 6781 in
column A in terms of column C. I am trying to compare column C to column E,
thats it!
by looking at column E, look at the same number at column A then column A is
associated with column C, so we are comparing column E to column C. 6781 in
column E = 53 compare that to column A (which means look at the value of
column A in column C. column A has to inputs of 6781 so add those two you get
49+6= 55, which gets 53<55.

A B C D E F
3795 59 TH ST ELEMENTARY 28 5548 22
6781 6 TH AVE ELEMENTARY 49 5582 50 <
6781 6 TH AVE ELEMENTARY 6 6781 53 <
5548 92 ND ST ELEMENTARY 21 3795 28 =
5582 93 RD ST ELEMENTARY 60







"Luke M" wrote:

I believe you posted this earlier in the forum! You need to explain yourself
more, simply saying "compute" is not a legitimate term for describing what
you want. You also tend to create sevearl run-ons in your logic, making it
unclear. You state that 6781 is less than 6781, which makes no sense. Also,
we have no idea what the 49+6=5550 has to do with anything. Is the text
embedded in the cells with numbers? If not, is it even important?

Why does the last line missing half the data??

Instead of repeatedly posting the same thing, try to give more detail.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"out0015" wrote:

A B C D
E F




3795 59 TH ST ELEMENTARY 28 5548 22
6781 6 TH AVE ELEMENTARY 49 5582 50 <
6781 6 TH AVE ELEMENTARY 6 6781 53 <
5548 92 ND ST ELEMENTARY 21 3795 28 =
5582 93 RD ST ELEMENTARY 60


Help: I need a formula to automatically compute column F. ie 5548 in column
D is greater than 5548 in coulumn A 2221. 6781 in column D is less than 6781
in column A 49+6= 5550.