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.

---

Count or sum first n values in a column with formulas

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:

Tip: in above formulas. A2 is the first value of the column list you want to sum or count, C2 indicates to sum or count first n values. You can change them as you need.

---

Count or sum first n values in a row with formulas

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:

Tip:

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.