Good evening, I would need the help of you experts to find the right function that sums the values in column C from the last Monday of the month previous to finish the last Sunday of the month.
In the attached file you will find the example:
from June to July results = 35
from July to August result = 28.
Thanks as always for your help and a greeting.
Suggest this user defined function
Open the VBA editor by hitting Alt F11.
Please Login or Register to view this content.
Insert a new module with Insert - Module
Paste in the above function
Go back to the sheet by hitting Alt F11.
In a suitable cell, enter =CountSpecial(F20) or any other cell on the sheet - doesn't matter which
Remember to save the workbook as a macro enabled workbook .xlsm
Martin
MRICE Hello, thanks for your time & work.
Unfortunately I tried your function and gives me different results.
In July, returns 29 instead of 28 SUM (C3: C30) (July) +7 SUM (C26: C32) (June) = 35
in August returns 28 instead of 25 SUM (C3: C27) (August) +3 SUM (C31: C33) (July) = 28
Maybe I was not well explained that the column to be added is the C 1 are all now but you can also other numbers.
Start the sum of column C from the last Monday of the month in column A, and you end up the sum, the last Sunday of the month following.
OK
New name for the function as it is summing
I note that cell A33 on the sheet1 tab contains a value for a Monday even though it is not visible. You need to delete this to avoid confusing the formula.evenPlease Login or Register to view this content.
Hello there we are still in Sheet2 as a result of missing 28 + 7 of sheet1 from A26: A32 = 35 total
In Sheet3 as a result of missing 25 +3 from Sheet2 A31: A33 = 28 total
If at you from different outcome, send me the file please thanks.
Please see the attached. I did find a bug where I had two lines in the wrong order.
Hello, we got almost to the solution. Now the totals are accurate.
I have a problem if I change some value in C3 example Sheet2 I put 4 instead of 1 total expected to rise from 35 to 38, but does not do it automatically.
I plugged in the bottom of the function: ActiveSheet.Calculate but does not work the same.
Can anything be done?
thanks again
Try
immediately after the first linePlease Login or Register to view this content.
Ok. perfect, everything works now.
Thank you very much for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks