Thread: Sum of Columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NotGood@All NotGood@All is offline
external usenet poster
 
Posts: 14
Default Sum of Columns

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