Yesterday I found this UDF designed to sum only the cell that match a specific background color.
For some reason it's rounding the result instead of giving a true sum. I assume it has something to do with the line "Dim ColIndex As Integer" but I am clueless about how to read this code. Other than the rounding it works great, can someone please tell me what to change so that it provides the real sum and not a rounded integer?Please Login or Register to view this content.
Bookmarks