![QLqaJEg.gif](/board/proxy.php?image=https%3A%2F%2Fi.imgur.com%2FQLqaJEg.gif&hash=29cd869b26013938ea43a6f72ed7a0b0)
Does any one know the formula to calculate top half rows/ bottom half rows of column D,
Simply by selecting ALL the rows in column D, as shown in the image
(I am not looking for the =SUM formula )
i have several tables like this and sometimes the number of rows may be odd/even