sumif problem

[RPW]

I have been using sumif to total cell values from 4 different sheets.

Now I added a fifth sheet. So I went into my sumif formula for a cell and
added the additional sumif for the new sheet. In the cell that is suppose to
show the total, I get ############. what did I do wrong?

Thanks!

 

[Don Guillett]

Larger total?

 

[Bob Phillips]

Try widening the column, or checking if the new sheet has any errors.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[RPW]

no, I already tried widening, but no values have been entered yet, so cell
should be blank right now, like all the others.