I have two sheets

Sheet1
A Column - Dates
B Column - Names

Sheet2
A Column - Names
B Column - Total

So..

How can I calculate sheet2 - Total..
let me explain it like this..
In sheet2 in Total I want to calculate by name, how many times I have a
certain name (under column B).. from this date 01.01.2006 - 10.01.2006

With this I can calculate (sheet2 - B Column) how much names "Alen" I
have
=COUNTIF(sheet1!B1:B100;"Alen").. but I want to filter it by dates
(sheet1 - A Column) from 01.01.2005 - 10.01.2005 (or any other)


Is there anyway to do this ?!

Sorry if you cant understand.. I'll help again if you don't manage...


--
alen_re
------------------------------------------------------------------------
alen_re's Profile: http://www.excelforum.com/member.php...o&userid=28331
View this thread: http://www.excelforum.com/showthread...hreadid=503628

=SUMPRODUCT(--(sheet1!$B$1:$B$100;"Alen"),--(Sheet1!$A$1:$A$100=--"2005-01-
01"),--(Sheet1!$A$1:$A$100<=--"2005-01-10"))
etc.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"alen_re" wrote in
message ...

I have two sheets

Sheet1
A Column - Dates
B Column - Names

Sheet2
A Column - Names
B Column - Total

So..

How can I calculate sheet2 - Total..
let me explain it like this..
In sheet2 in Total I want to calculate by name, how many times I have a
certain name (under column B).. from this date 01.01.2006 - 10.01.2006

With this I can calculate (sheet2 - B Column) how much names "Alen" I
have
=COUNTIF(sheet1!B1:B100;"Alen").. but I want to filter it by dates
(sheet1 - A Column) from 01.01.2005 - 10.01.2005 (or any other)


Is there anyway to do this ?!

Sorry if you cant understand.. I'll help again if you don't manage...


--
alen_re
------------------------------------------------------------------------
alen_re's Profile:
http://www.excelforum.com/member.php...o&userid=28331
View this thread: http://www.excelforum.com/showthread...hreadid=503628