sumif
 

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!

sumif
 

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!