| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to sum a row of cells containing an error message to overlook
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to sum a row of cells containing an error message to overlook
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! "Amy V" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Counting only active cells | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Hybrid Mode
