| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with sumif function
both of the above worked now I am trying to include mutiple ifs.
basicily it is a calculation sheet in which you enter quanitities in b3 #1-1000 then total colors in b5 #1-6 then the ending result is based upon fixed value in b16 thru i23 which is in conjunction with the value in b3 plus another fixed value in b18-b23 with these cost being in conjunction with b5 I have a link for a pdf below to help. www.aaufl.com/customart/pricecalculations.pdf the blue cell determines the horizontal scale the you add the total costs for the green cells which is determined by the vertical scale which wala give you your total in the red cell. this is probably confusing but if you can help thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
| How do I use the TODAY function with the SUMIF function? | Excel Worksheet Functions | |||
| SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
| Can SUMIF function include AND function | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Threaded Mode
