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!

Larger total?

--
Don Guillett
SalesAid Software

"RPW" wrote in message
...
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!

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" wrote in message
...
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!

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

"Bob Phillips" wrote:

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" wrote in message
...
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!