sumif

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif & Sort 3
SumIf AND 6
Criteria Syntax in SUMIF formula 4
SUMIFS with Dates 1
SUMIF function formula won't work, help 6
SUMIFS error 1
Wildcard * for SUMIFS 2
SUMIF using 2 cells that equal each other 1

Back
Top