Evening again tonight
I want to do a calculation of my loan left I have for an iPad
Is it possible instead of the number 500 for the loan have something like =500-(Formula for grabbing every iPad entry I have in my transactions) so that will show a true value of the loan left?
Any input appreciated
Jonny
Try this one
=SUM(J5:J9)-SUMIF(H5:H9,"iPad",J5:J9)
Or this
=SUMIF(H5:H9,"<>"&"iPad",J5:J9)
Last edited by AlKey; 11-16-2014 at 03:13 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hmmm that is close but it shows me 400 for taking 150 off 500?
Any advice?
it is not 150 it is only 100. Look at your spreadsheet. There are two entries for iPad both for $50.00 each.Originally Posted by flapface
Or just this...
=SUMIF(H5:H9,"<>Ipad",J5:J9)
Agree on the 400 total, J7 and J9 are both ipad with a value of 50
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sorry my mistake you are both right they were both 50 I just changed one entry to 100 to see how it would affect the formula
It seems that the formula won't update to the new values?
If you changed an ipad entry, it wont change the total, because those values are being excluded. Try changing a non-ipad value
Aww okay sorry I think I could have been clearer in my description
C4 is the starting value of the loan I would then want to subtract the entries away from the starting value all in one cell so if starting value is 500 I would like C4 to be something like =500-(all entries for "iPad"), does that make sense?
Thanks
Jonny
Yes, that is a bit different from your 1st question.
TRy this...
=$C$4-SUMIF($H$5:$H$9,"Ipad",$J$5:$J$9)
or this...
=$C$4-SUMIF($H:$H,"Ipad",$J:$J)
Perfect! Sorry for not being clear enough
Thanks for the help guys!
Im glad we got it sorted out for you, and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks