Function in plain english

**MichaelTzu** · 03-08-2016, 04:24 PM

I have been trying to decipher a freebie excel workbook. It is not locked so free to play with to my hearts content.

Can anyone decipher this for me?

=SUMIF(Results!C:C,'Individual Tipster Profits'!A12,Results!L:L)

I have tried tracing precedents but points to what appears to be an empty cell Screen Shot 2016-03-08 at 20.22.12.png

I am a complete novice at this.

Thanks

Michael

**Speshul** · 03-08-2016, 04:30 PM

I don't see a workbook attachment - but here is what the formula is doing:

SUMIF will add up the cells in a range which meet a condition.

So, it is looking at Column C of the Results page, and comparing it to the cell A12 on the Individual Tipster Page. Every time they match, the value in Column L of Results is summed up.

For example, if

C2 = 1
C3 = 1
C4 = 2
C5 = 1

and

L2 = 10
L3 = 10
L4 = 10
L5 = 50

And the cell A12 on the Tipster page is a "1", the result will be 70. The Bolded numbers below are being added, because the Red numbers match the criteria (A12 on Tipster page)

C2 = 1
C3 = 1
C4 = 2
C5 = 1

and

L2 = 10
L3 = 10
L4 = 10
L5 = 50

Hope this helps.