Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF excluding #N/A
I am trying to add different cells located in different worksheets (tabs)
within the same workbook. I know I can use =SUMIF(A1:A5,<#N/A) without error. The problem I am having is trying to add different cells not grouped together while using SUMIF. Example, =SUMIF(A1+A3+B5+C20, <#N/A). If B5 =#N/A for instance, then my SUMIF will not work. Any solutions? Thank you in advance for help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF excluding #N/A | Excel Discussion (Misc queries) | |||
Min Excluding Value | Excel Discussion (Misc queries) | |||
Excluding subtotals from SUMIF function | Excel Worksheet Functions | |||
Excluding Zero's from Average (SumIF / CountIF) | Excel Worksheet Functions | |||
MIN excluding 0s | Excel Worksheet Functions |