Thread: 3 results possible on every day. add up the number of each on each day.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default 3 results possible on every day. add up the number of each on each day.
Hello,

Am Mon, 23 Jan 2012 22:45:50 +0100 schrieb Claus Busch:

in B1:
=SUMPRODUCT(--(Sheet1!A1:A200=A1),--(Sheet1!H1:H200="Y"))

change the relative ranges to absolute ranges:
=SUMPRODUCT(--(Sheet1!$A$1:$A$200=A1),--(Sheet1!$H$1:$H$200="Y"))



Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote