Hello, Looking for some help on this worksheet that I have. When there are exceptions they are logged into this spreadsheet. It is quite large spreadsheet because we have months worth. What I am trying to accomplish is when we enter a Date Clrd would like it to subtract the amount from the Excep total Amt and enter it next to remaining balance. Any suggestions would be greatly appreciated. Attached is a small example.
how many dates can be entered into the Sheet ?
we could sum up all the dates entered
so
=SUMIF(D4:D16,">"&0,C4:C16)
then use that to subtract from the total
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Only one date cleared will be entered. I can use this formula and then subtract from total as you stated, that would work. Thank you!
you are welcome
OR NOT Blank
=SUMIF(D4:D16,"<>",C4:C16)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks