Hi all
Im trying to calculate the rolling total based on banking name, transation date.
im not sure what date range to add or how to incorporate it into my sumifs formula in cell R5.
Here is the formula in cell R5
<code>
=SUMIFS($E$5:E210,$H$5:H210,$H5)
</code>
im trying to replicate what's in column L, as that has the manual calculation.Any help is apprecaited!
try using
=SUMIFS($E$5:E5,$H$5:H5,$H5)
in row 5 and copy down
gives the same result as your manual calc
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.
thanks ETAF - that worked, i guess i shouldve only anchored until the active cells
I do have another issue im running into - see attached file
basically, in the "recon" tab, im trying to show the opening balance in column G10 down, i used the index match formula, however, if the date doesn't exist, its showing N/A error.
Is there a way to use this formula or a diff that shows the balance up to the specified date in column F? The data tab, has the amount and running total columns along with the transaction date.
thanks in advance!
so the 1st feb 23 does not exist in the list
what date would you want to use ?
index/match brings back only 1 value- so if you do have multiple dates and matching B1 - it will only return the first
as its a new question probably better to strat a new thread , will get more members looking at it then
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks