vlookup addition
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
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)
.
Relevant Pages
- Re: vlookup addition
... I love the sumproduct idea - ... what am I doing wrong and can it calculate a sum if one of the items is not ... still need to have an amount even if the Accounting category is missing. ...
(microsoft.public.excel.worksheet.functions) - Re: Conditional Format With SUMIF
... Anyone have any ideas as to how to see if the sum of BS Amount per ... day per account is the same as the sum of DT Amount for the same day ... >If a BS Amount is missing, there is no way knowing how many DT Amounts ...
(microsoft.public.excel.worksheet.functions) - Re: Conditional Format With SUMIF
... I am looking to see if the sum of BS Amount per day per account is the ... If a BS Amount is missing, there is no way knowing how many DT Amounts ...
(microsoft.public.excel.worksheet.functions) - Re: why dont you two poofters....
... You prompt nearly if Georgette's shape isn't missing. ... special legal offences will loosely should the cups. ... Are you horizontal, I mean, accounting in search of negative ... chance will point out of the helpful federation. ...
(rec.heraldry) - Re: Examples of SQL anomalies?
... SUM should only return NULL ... suspect. ... Extrapolation is problematic because there is no reason to ... It sounds to me like you're arguing against missing information. ...
(comp.databases.theory) |
|
