Excel: How do I reference an entire row except for a couple of cells?
Fresh3 days ago
Mar 15, 2026167312 viewsConfidence Score0%
0%
Problem
I want to be able to sum together the values of an entire row except for the first 2 cells. So something like this: How do I do this?
Error Output
=sum(A3:A*infinity*)
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Excel: How do I reference an entire row except for a couple of cells?
Low Risk
Something similar has been asked before and I'll repeat this answer: just put: because that's the max number of cells per column / row in Office 2007 and 2010. (65536 is max for before 2007.) (For columns, the max column name is XFD in 2007 and 2010…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix