Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am using the following to add together the two categories. How can I
change it to still give me a sum even if one of the categories is missing? Example: The June report shows a category of Sales & Logistics but doesn't even mention Accounting. Using this formula gives me an error although I still need to have an amount even if the Accounting category is missing. Is this possible? Thanks in advance!!! =VLOOKUP("Accounting",$G$1:$H$205,2,FALSE)+VLOOKUP ("Sales",$G$1:$H$205,2,FALSE))+VLOOKUP("Logistics" ,$G$1:$H$205,2,FALSE) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Addition in Excel | Excel Discussion (Misc queries) | |||
Subtraction/addition | Excel Discussion (Misc queries) | |||
Addition? | Excel Discussion (Misc queries) | |||
addition | New Users to Excel | |||
row addition | Excel Worksheet Functions |