q; find sum and count

J

JIM.H.

Hello,
In Excel Macro, how can I find
1. the sum of numbers in column Z
2. and count of number of rows in column Z
Thanks,
 
B

Bob Umlas

SumOfNumbers = Application.Sum(Range("Z:Z"))
CountOfRows = cells(rows.count,26).end(xlup).Row 'if you mean the # of
used rows (including blanks)
 
Top