Layout

  • Thread starter Thread starter Squidgee
  • Start date Start date
S

Squidgee

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
 
Many thanks jacob, u r a star!!

Jacob Skaria said:
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
Click to expand...
 
Back
Top