software

I am using multiple quot;GET PIVOT DATAquot; 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 quot;SUM IFquot; function
asking it to add all the cells in the range specified if there is a number
there...
HELP!

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

quot;Amy Vquot; wrote:

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