counting the the result of cell in the column on 4 diferent worksheet with regards of date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I just want to know how I can count the result of cell on the different worksheet. ex. I have one files of xls. and it has 4 deifferent worksheet. each worksheet has a B column each date record at B column correspond to c column. what I want is how to count the value of C column with regards to date at B column

Regards,agl
 
Something like

=SUMPRODUCT((Sheet1!B1:B100=DATE(2004,1,1))*(Sheet1!C1:C100))+SUMPRODUCT((Sh
eet2!B1:B100=DATE(2004,1,1))*(Sheet2!C1:C100))+SUMPRODUCT((Sheet2!B1:B100=DA
TE(2004,1,1))*(Sheet2!C1:C100))+...

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

agl said:
Hi. I just want to know how I can count the result of cell on the
Click to expand...
different worksheet. ex. I have one files of xls. and it has 4 deifferent
worksheet. each worksheet has a B column each date record at B column
correspond to c column. what I want is how to count the value of C column
with regards to date at B column.
 
Back
Top