Hello,
The following code works if there are 4 values in B2:B, however if there are only 3 and one of the values is zero or blank I get an overflow error. Can a line of code be put in that if the value of B2:B = 0 Then it is ignored or not calculated? I have attached the spreadsheet as well.Thanks.
Please Login or Register to view this content.
Bookmarks