Subtoal excluding hidden columns
Very cute!
Shaen
"Teethless mama" wrote:
=SUM(A1,C1,F1,H1)
adjust to suit
"Trevor" wrote:
Does anyone how I can sum many columns within a row but exclude hidden colums
from the calculation?
The subtotal(109,"range") works for rows but not columns
Thank you!
|