I currently have the following formula that will sum B2:AA2 and then multiple by 24. However there is a possibility I could add or remove columns between B and AA.
Is there way to modify the formula to something like B2 to whatever the last populated cell is and then *24?
=SUMPRODUCT((Consumer!B2:AA2)*24)
Last edited by Wheelie686; 03-05-2020 at 05:59 PM.
If you add or remove columns BETWEEN columns B and AA, the formula will auto adjust.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Is this resolved?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks