HI Guys

ihave the following formula on a spreadsheet

=SUMPRODUCT(--($C4:$C644="CON"),--(MONTH(D4:D644)=8),--(YEAR(D4:D644)=2010))

My question is this, how can i get the result to appear on a different sheet
instead of the cell where it is?

Thanks in advance for your help

Suppose your data is in Sheet1; try the below formula in which ever
sheet/cell you would like to..

=SUMPRODUCT(--(Sheet1!$C4:$C644="CON"),--(MONTH(Sheet1!D4:D644)=8),--(YEAR(Sheet1!D4:D644)=2010))

The formula can be further shortened to

=SUMPRODUCT(--(Sheet1!$C4:$C644="CON"),--(TEXT(Sheet1!D4:D644,"mmyyyy")="082010"))


If this post helps click Yes
---------------
Jacob Skaria


"Squidgee" wrote:

HI Guys

ihave the following formula on a spreadsheet

=SUMPRODUCT(--($C4:$C644="CON"),--(MONTH(D4:D644)=8),--(YEAR(D4:D644)=2010))

My question is this, how can i get the result to appear on a different sheet
instead of the cell where it is?

Thanks in advance for your help

Many thanks jacob, u r a star!!

"Jacob Skaria" wrote:

Suppose your data is in Sheet1; try the below formula in which ever
sheet/cell you would like to..

=SUMPRODUCT(--(Sheet1!$C4:$C644="CON"),--(MONTH(Sheet1!D4:D644)=8),--(YEAR(Sheet1!D4:D644)=2010))

The formula can be further shortened to

=SUMPRODUCT(--(Sheet1!$C4:$C644="CON"),--(TEXT(Sheet1!D4:D644,"mmyyyy")="082010"))


If this post helps click Yes
---------------
Jacob Skaria


"Squidgee" wrote:

HI Guys

ihave the following formula on a spreadsheet

=SUMPRODUCT(--($C4:$C644="CON"),--(MONTH(D4:D644)=8),--(YEAR(D4:D644)=2010))

My question is this, how can i get the result to appear on a different sheet
instead of the cell where it is?

Thanks in advance for your help