Counting

[alen_re]

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...

[Bob Phillips]

=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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>