Two IF parameters needed ... I think. Fantasy Movie Box Office!

[mstrchapl]

I have very little excel experience. Basically, I have two columns on one sheet. I'm cataloging sales. Only 8 people will be buying. On another sheet, I have it set to say " =IF(Sheet1!H3:H104="Brian",100-Sheet1!I3,100) meaning that if the name appears in the cell to subtract the purchase price from their starting balance. However I can't find a way to use that name more than once without it subtracting ALL of the numbers from the field. I know this is confusing. SummerBO2014Latest.xls3

The file is attached. Basically I want to be able to deduct dollars from each person as we find out what they've purchased. Can anyone help?

[etaf]

does this help
=100-SUMIF(Sheet1!H:H,"Brian",Sheet1!I:I)

if you put the same name into sheet2!A:A and also sheet1!H:H

then all you would need is =100-SUMIF(Sheet1!H:H,A1,Sheet1!I:I)
and then copy down the sheet2

[mstrchapl]

You are ...

a GENIUS!

How do we mark this **** as solved?

I need to adjust it for all the names, but I think we're in business! Thank you so much!

[etaf]

I need to adjust it for all the names

as mentioned

if you put the same name into sheet2!A:A and also sheet1!H:H

then all you would need is =100-SUMIF(Sheet1!H:H,A1,Sheet1!I:I)
and then copy down the sheet2

How do we mark this **** as solved?

Select Thread Tools-> Mark thread as Solved.

if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here