Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif?
Hello,
I would like a formula the calculates a total as it is is the word "No" iis in a cell and doubles the amount if that same cell says "Yes". I J K L M 32 Feet Inches 33 How Many: 2 Length: 10 8 34 Open Beam: Yes Width: 12 3 35 Total SF: ? Right now the formula that I have for cell M35 is: =SUM((L33+(1/12*M33))*(L34+(1/12*M34))*J33) What I would like it to do is double the answer is the word "Yes" in in cell J34. If you have a better formula to calculate the initial total, please feel free to change it. Can anyone help? Thank you for any help you can give! Scott A |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif (maybe) | Excel Discussion (Misc queries) | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |