If you isolate the criteria section of the formula -
TotalView!B86&1&TotalView!C86 - and put it into a cell (
=TotalView!B86&1&TotalView!C86 ) you should see that the value in cell B86 is
concatenated to 1 and to the value in cell C86 e.g. B86 = 55, C86 = 23, you
will get 55123

"Diana" wrote:

I have the following function that someone else has written
=SUMIF('2005 Actuals'!A:A,TotalView!B86&1&TotalView!C86,'2005 Actuals'!P:P)
The problem I have is that I can figure out where the 1 came from. I know
that it is a criteria but I am not sure what it means. Also if I change it
and use 2 instead I noticed that the number in my cell has dicreased.
2005 Actuals and TotalView are the sheet names in the same workbook.

Thanks!