|
Layout
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 |
Layout
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 |
Layout
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 |
| All times are GMT +1. The time now is 06:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com