q; find sum and count

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
SumOfNumbers = Application.Sum(Range("Z:Z"))
CountOfRows = cells(rows.count,26).end(xlup).Row 'if you mean the # of
used rows (including blanks)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table calculated field Count(field) / sum(field) 0
Excel VBA Macro to do this? 19
Search for a sum! 4
CONDITIONAL SUM FOR MULTIPLE CRITERIA IN SINGLE RANGE 1
X,Y,Z values to be extracted and posted respectively in excel 2
counting formula 3
How to find matches, pairs of two SUMPRODUCT? 7
Which function to use......and how? 4

Back
Top