#VALUE! error in formula

I have a formula that looks like this:

=sumbycolor(S331,T330:AG330)

for which I keep getting a #VALUE! error.

I am asking it to add up the contents of cells following, the content of the cells following is determined this way:

=IF(AND(SUM(T326:T329)<=$B344,SUM(T326:T329)>0),$B344-SUM(T326:T329),IF(SUM(T326:T329)>$B344,"",IF(SUM(T326:T329)<1,"")))

I do the color change manually for amounts that I need to show as a separate project.

I think I am getting the error because I have text in the cells I am trying to add up?

I think I am probably doing this the most difficult way possible, and I think this is driving me crazy.

Thanks.

I think it was a vba I found online.

Excel Forum Submission.xlsm

I have attached a sample of the spreadsheet. If it asks for a password - RedBull.

What I am trying to do is create this spreadsheet to record and track data for payroll, and the remaining data will feed to a second spreadsheet which is then submitted for processing. The sumbycolor part is to track $ in the next province for WCB.

EJ

You are a genius.

Thank you.

I would like to say that I have it all figured out and I won't be back with any more questions but I probably will

I have one more question on this one. It doesn't recalculate automatically. With the sumbycolor I hit F9 and the sheet recalculated - is there an equivalent here. If I color my cells, the result does not change unless I paste the formula over a second time.

[QUOTE=Tony Valko;3494396]

Most people don't know that's how it works when they set out to do it.

/QUOTE]

Yes, that would be me I am mostly self taught and can't get into the course I want until February, and that will be too late for this project. For now I will just continue to use the paste every time I change the cell color.

And so it does, thanks.