LinkBack URL
About LinkBacks
can someone please help with this??
I want to show the total of all the cells that are currently overdue and minus the paid amount.
can someone please help with this??
I want to show the total of all the cells that are currently overdue and minus the paid amount.
What's your expected result?
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
I want to try and have all the overdue amounts totalled down the bottom in cell G33 but as you will see the overdue invoices change every day so the overdue total would have to also
What's the critiria for overdue?
Red cells, negative values?
yes that's right the red cells are the overdue ones and the green negative are not overdue.
the red and green cells have days overdue totals in them
anyone pleaseee
If you need your calculation based on colors you need VBA.
Are you happy with this solution?
=sumifs(g3:g29,h3:h29,">0")-g31
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks