Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have 2 columns, the answer for both columns is yes or no. I want a 3rd
column to sum both of these columns according to the answer. The value for column A is $100.00, the value for column B is $50.00, so if both columns are Yes the sum is $150.00, if just column A is Yes, the sum is $100.00, if just column B is Yes, the sum is $50.00. Is that possible or should I take another path? Thanks -- NotGood@All |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
putting 2 long columns into multiple columns in excel page and sor | Excel Discussion (Misc queries) | |||
to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) |