LinkBack URL
About LinkBacks
Hi, I'm making a template to fill in data in monthly cells, namely January, February, March.
But I am having difficulty making the downward addition formula for each column.
Any suggestions for improving my macro?
Hi, I'm making a template to fill in data in monthly cells, namely January, February, March.
But I am having difficulty making the downward addition formula for each column.
Any suggestions for improving my macro?
Try
in B6
Formula:
Please Login or Register to view this content.
in B7
Formula:Please Login or Register to view this content.
You should now be able to fill in the other formula.
And are you still using Excel 2007? If not, please update your profile with your current version.
Last edited by JohnTopley; 01-30-2024 at 05:11 AM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Hi JohnTopley
I've never been familiar with the SUMPRODUCT formula, but looking at the way you use the formula it looks simpler.
How do I use the sumproduct formula in cell B8?
For B8
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks