Layout

[Squidgee]

HI Guys

ihave the following formula on a spreadsheet

=SUMPRODUCT(--($C4:$C644="CON"),--(MONTH(D4644)=8),--(YEAR(D4644)=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

 

[Jacob Skaria]

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!D4644)=8),--(YEAR(Sheet1!D4644)=2010))

The formula can be further shortened to

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


If this post helps click Yes

 

[Squidgee]

Many thanks jacob, u r a star!!

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!D4644)=8),--(YEAR(Sheet1!D4644)=2010))

The formula can be further shortened to

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


If this post helps click Yes