I'm creating a formula that calculates the total of columns, multiplies it by 2, then divides it by 14 which I have done, the challenge I am having is that I also need it to take calculate the number of rows totaled and add 2 per row
So if I have 13 rows in a column that I have totaled up. I need to add 26 to the number that I have come up with after completing the formula describes above. What is the best way to do this?
Bookmarks