Although not a newbie I am not an advanced user, but do understand logic and I do some programming.
Having difficulty getting formula to work where desired result is SUM of cell range divided by X WHERE another column entry equals a certain month.
I need the answer to NOT be VBA, script, etc, but an Excel Formula entered into desired cell.
Thinking SQL type logic I would say "SUM of cell range A / # WHERE MONTH of cell range B = 4 (April)
my current formula is:
=SUMPRODUCT(($K$2:$K$196)/N9),IF(MONTH($F$2:$F$196=4))
have also tried:
=IF(MONTH($F$2:$F$196)=4, SUM($K$2:$K$195/N9)
Column F has date in YYYY-MM-DD format and that is working for several other Formulas being used.
Column K has whole number integers from "0" thru "99"
"N9" (or NX if you will) has a valid integer from 1 thru 99
If more info needed Please Ask and I will provide
I could duplicate, reduce and redact the actual spreadsheet but hoping not to have to do so as it would require hours of work.
Thank any and all for assistance.
Having difficulty getting formula to work where desired result is SUM of cell range divided by X WHERE another column entry equals a certain month.
I need the answer to NOT be VBA, script, etc, but an Excel Formula entered into desired cell.
Thinking SQL type logic I would say "SUM of cell range A / # WHERE MONTH of cell range B = 4 (April)
my current formula is:
=SUMPRODUCT(($K$2:$K$196)/N9),IF(MONTH($F$2:$F$196=4))
have also tried:
=IF(MONTH($F$2:$F$196)=4, SUM($K$2:$K$195/N9)
Column F has date in YYYY-MM-DD format and that is working for several other Formulas being used.
Column K has whole number integers from "0" thru "99"
"N9" (or NX if you will) has a valid integer from 1 thru 99
If more info needed Please Ask and I will provide
I could duplicate, reduce and redact the actual spreadsheet but hoping not to have to do so as it would require hours of work.
Thank any and all for assistance.