How to sum or count first n values in an Excel column or row?Have you ever imaged to sum or count only first n values in an Excel column or a row? For example, I have a list of values, and now I want to sum first 3 values only of the list as below screenshot shown. In this article, I introduce some formulas which can quickly sum or count first n values in a column or row in Excel.
Excel Productivity Tools
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 70% of your time and solve 80% Excel problems for you. 300+ advanced features designed for 1500+ work scenario, make Excel much easy and increase productivity immediately. 60-day Unlimited Free Trial
Sum first n values only, you can do as below:
Select a blank cell which you will put the result into, and enter this formula =SUM(OFFSET($A$2,0,0,C2)), press Enter key to calculate the result. See screenshot:
Count first n values excluding text only, you can do as below:
Select a blank cell and type this formula =COUNT(OFFSET($A$2,0,0,C2)), press Enter key to get the result. See screenshot:
If you want to count or sum first n values in a row, you can do as below
Select a blank cell that you want to put the calculated result into, and enter this formula =SUM(OFFSET(A20,0,0,1,A23)), press Enter key to get the calculation. See screenshot:
1. To count first n numeric strings in a row, use this formula =COUNT(OFFSET(A20,0,0,1,A23)).
2. In above formulas. A20 is the first value in the row you want to calculate, A23 indicates to count or sum first n values, you can change them as you need.
|Kutools for Excel: The 200 functions you must have in Excel, you can free download from here|