Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function with extras.
Looking for how to:
Example a b c d e f g h 1 Jan paid Feb paid march pd $total paid $total not paid 2 $30 N $25 N $22 Y (need formula) (need formula) i would like to create a formula for $total not paid cell H2. Any time there is a "n" in a cell, I would like the amount in the cell to the immediate left of all "n" to sum up keep a running total in the H2 cell, $total not paid. then I would create a second formula for the "y" for the $total paid for G2 cell. Can anyone help with a formula? mary -- MARY |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function with extras.
Mary,
This is not the first time you ignore answers to previous posts. Please do not do that!!! Will you please read those answers and explain why that does not answer your question? Please do not post a new question again. First check the answers already given and if they don't help you enough, answer in that same thread, don't start a new one. -- Kind regards, Niek Otten Microsoft MVP - Excel "MARY" wrote in message ... | Looking for how to: | | Example | a b c d e f g | h | 1 Jan paid Feb paid march pd $total paid $total | not paid | 2 $30 N $25 N $22 Y (need formula) | (need formula) | | i would like to create a formula for $total not paid cell H2. Any time | there is a "n" in a cell, I would like the amount in the cell to the | immediate left of all "n" to sum up keep a running total in the H2 cell, | $total not paid. then I would create a second formula for the "y" for | the $total paid for G2 cell. | | Can anyone help with a formula? | | mary | | | -- | MARY |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function with extras.
As said before, please don't continue to repost the same question in a new
thread. Instead, reply to responses in your old threads. Any way, since you provided a little more info, try this. For no: =SUMPRODUCT(--(B1:F1="N"),A1:E1) For Yes: =SUMPRODUCT(--(B1:F1="Y"),A1:E1) -- "MARY" wrote in message ... Looking for how to: Example a b c d e f g h 1 Jan paid Feb paid march pd $total paid $total not paid 2 $30 N $25 N $22 Y (need formula) (need formula) i would like to create a formula for $total not paid cell H2. Any time there is a "n" in a cell, I would like the amount in the cell to the immediate left of all "n" to sum up keep a running total in the H2 cell, $total not paid. then I would create a second formula for the "y" for the $total paid for G2 cell. Can anyone help with a formula? mary -- MARY |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Spacebar extras removal | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |