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!