Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional counting with Excel | Excel Worksheet Functions | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
Counting... | Excel Worksheet Functions | |||
counting | Excel Worksheet Functions |