How to sum a row of cells containing an error message to overlook

G

Guest

I am using multiple "GET PIVOT DATA" functions in a summary spreadsheet.
Basically I want to sum each row of cells for a grand total in the last
column, but I cannot get Excel to calculate the sum overlooking the #REF!
messages in some of the cells. I want to create sort of a "SUM IF" function
asking it to add all the cells in the range specified if there is a number
there...
HELP!
 
G

Guest

I figured it out myself...
All you have to do is use a "SUM IF" function and have the criteria be >0 so
it only adds numbers greater than 0 - and disregards the error message in
some of the cells. :)
YEA!
 

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 do I sum cells that have values from a text formula? 4
Sum cells using criteria from a row and a column 2
Excel Sum numbers in cells that also contain text 34
How to sum more than 30 cells 9
Excel Add ^ to a row of cells containing letters 3
formula to make the value in a cell, to a row in a sum function 5
Calculate total metric based on sum of metric over specific time f 1
Sum of an array 1

Top