I have a range in a spreadsheet that changes size as items are added and expire where I insert/delete rows needed which expands/contracts the data range. On a separate sheet (tab), I reference to ceratin cells in the first sheet (tab). When a row is added, the forumals in the second sheet do not account for the inserted row.
ex. =A32
=A33
becomes =A32
=A34
how can I get the second sheet to reflect the inserted row?
I'd recommend perhaps using arrays formulas such as SUMPRODUCT, SUMIFS, COUNTIFS, etc to always pull all records and simply narrow the field down by date criteria.
Are you able to attach a sample worksheet with your data formatting, so we can see which application or adjustment may be most relevant/helpful?
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks