D
David Lipetz
Folks,
I'm really struggling with this one.
I've got 354 rows of data (rows 3:352). In column G there may be a date. In
column M there is a number (1-12) which represents a monthly period, and in
column O there is a dollar amount which represents a montly invoice total.
I need to construct a formula which calculates the sum of O for a specific
period M where there is a date entered (non-blank cell) in G.
The formula below is what I constructed but it does not work. Rather it
calculates the sum of O for the specified period in M but then multiplies
the sum ($16,200) by the number of non-blank cells found in G (3) for a a
result of $48,600.
{=SUMPRODUCT(--(Master!$G$3:$G$352<>0)*SUMIF(Master!$M$3:$M$352,"3",Master!$O$3:$O$352))}
An example of what I want it to do:
For all rows where M = 3 and G is non-blank
Sum value of O
Your assistance would be greatly appreciated.
Thanks,
David
I'm really struggling with this one.
I've got 354 rows of data (rows 3:352). In column G there may be a date. In
column M there is a number (1-12) which represents a monthly period, and in
column O there is a dollar amount which represents a montly invoice total.
I need to construct a formula which calculates the sum of O for a specific
period M where there is a date entered (non-blank cell) in G.
The formula below is what I constructed but it does not work. Rather it
calculates the sum of O for the specified period in M but then multiplies
the sum ($16,200) by the number of non-blank cells found in G (3) for a a
result of $48,600.
{=SUMPRODUCT(--(Master!$G$3:$G$352<>0)*SUMIF(Master!$M$3:$M$352,"3",Master!$O$3:$O$352))}
An example of what I want it to do:
For all rows where M = 3 and G is non-blank
Sum value of O
Your assistance would be greatly appreciated.
Thanks,
David