As shown in Cols I - M on SUMMARY sheet, Code should count how many orders a client has placed across three companies for what products, and show the combined volumes and values.
Have set Named Ranges, but the code calling COUNT IF and SUM IF are not working, and can't see why?
All solutions, suggestions and alternatives welcome as ever
Please Login or Register to view this content.
Ochimus
It's Application.WorksheetFunction not Application.Function
Sticking On Error Resume Next at the start of a routine and leaving it active the whole time is not good practice.
Rory
Hi there,
As Rory says, you should NEVER use "On Error Resume Next" just because your code doesn't work! It is a very useful tool to have available, BUT you should use it only in a very controlled way, and only when you know exactly what you are doing.
If you had NOT included it, the highlighted errors would have been identified when your code ran. The fact that the errors were ignored has possibly contributed to the incorrect calculations.
Please Login or Register to view this content.
Hope this helps,
Regards,
Greg M
Many thanks for prompt feedback and pointers, which I put into the Code.
When it still didn't work, I realised the key error was the Client Name is added to the first row of each block, but the code was looking for it on the last row.
Added a seperate variable (w) for the Name row, and everything now works perfectly.
Now marking this as closedPlease Login or Register to view this content.
Ochimus
Last edited by Ochimus; 10-05-2020 at 10:41 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks