i've been using this formula for calculating a total in a column. I need to modify it to calculate the total of TWO columns
=COUNT(TRANSPOSE(INDIRECT(ADDRESS(2+3*ROW(INDIRECT ("1:75")),3))))+COUNT(TRANSPOSE(INDIRECT(ADDRESS(3+3*ROW( INDIRECT("1:75")),3))))
thanks.
Bookmarks