Help With Sum

C

Chris

I am trying to total a range of cells, G12:G46 as I enter info into CA. Some
cells have error #N/A and it is stopping me from completing my project. Help
Please...
 
T

T. Valko

Fix the cells that have the errors:

=IF(ISERROR(your_formula),0,your_formula)

If you might want the errors:

=SUMIF(G12:G46,"<1E100")

=SUMIF(G12:G46,"<>#N/A")
 
M

Marcelo

=sumif(a1:a1000,"<>#N/A")

hth
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"Chris" escreveu:
 

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

How to implement two shifts per day with multiple teams 0
Need Help with a VBA subroutine 0
SUM TOTAL 2
Cumulative formula for word table 0
Visual basic functions 3
Empty cell warning 0
How do I input these formulas into cells that I want written in? 4
My calendar keeps returning to working hours of 08:00h to 17:00h even after I set it to 24h? 1

Top