• 0 Vote(s) - 0 Average
• 1
• 2
• 3
• 4
• 5
Excel: How to Sum Values in a Column with N/A or blank cells

Hello everyone, I search and search for excel commands so I've decided to post my finding here that help me. If you find any of my Postings helpful and want to donate for my time, please check my profile! On with the tutorial.

Sum column cells ignore #N/A with formula

There is a formula can help you quickly sum up the column ignore #N/A.

Select a blank cell, C3 for instance, and type this formula

Code:
`=SUMIF(A1:A14,"<>#N/A"),`

press Enter key to get the result.

Tip: in above formula, A1:A14 is the column list you want to sum up, you can change it as you need.

Forum Jump:

 Users browsing this thread: 1 Guest(s)

 Active Threads Steam - Team Fortress 2 Update Released Last Post: GilbertBib Today 08:34 AM » Replies: 1 » Views: 128 [Tut] Pandas cut() – A Simple Guide with... Last Post: xSicKxBot Yesterday 10:59 PM » Replies: 0 » Views: 27 (Indie Deal) Grab Die Young for FREE & c... Last Post: xSicKxBot Yesterday 10:59 PM » Replies: 0 » Views: 4 Blender 3 Released Last Post: xSicKxBot Yesterday 10:59 PM » Replies: 0 » Views: 4 AppleInsider - Apple execs explain the d... Last Post: xSicKxBot Yesterday 10:58 PM » Replies: 0 » Views: 3 Microsoft - ID@Xbox Winter Game Fest Dem... Last Post: xSicKxBot Yesterday 10:58 PM » Replies: 0 » Views: 4 News - Talking Point: What Can This \$120... Last Post: xSicKxBot Yesterday 10:58 PM » Replies: 0 » Views: 5 Xbox Wire - Get Ready for the Alien Inva... Last Post: xSicKxBot Yesterday 10:58 PM » Replies: 0 » Views: 5 News - Tsareena brings grass-fuelled glo... Last Post: xSicKxBot Yesterday 10:58 PM » Replies: 0 » Views: 4 [Tut] User Registration in PHP with Logi... Last Post: GilbertBib Yesterday 01:45 PM » Replies: 1 » Views: 52