Counting

A

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

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)
 
Top