Thread: Layout
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Squidgee Squidgee is offline
external usenet poster
 
Posts: 4
Default 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