In the AR sheet is an example output where the red cells are the incorrect values, with the corresponding correct values under it.
The macro is called "Sheetloop". Not really sure what the issue is. I have tried possibly changing the variables from long to Double, to no avail.
I figure it has something to do with the <> argument in the sumif formula.
[/CODE]
Please Login or Register to view this content.
Hi before even trying your macro
I placed two formulas in the T column this more or less is the result, isn't it?
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
I think it might be more of a math problem than a code problem. It happens when summing and averaging averages.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Thats the correct output but the formula is not negating little rock
That is true, but the strange is that if you subtract Little Rock, the value is negative, how can it be that the answer is correct?
I was assuming that you wanted to calculate Little Rock and the all the others except Little Rock, and yes the formulás result is the value you expect even including Little Rock, very strange indeed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks