Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to check for a date range match in one column and then count thevalues equal to in another
Hi,
Does anybody have the answer to this: I have a worksheet with a "Date Column" and a "Model No. Column" I want to be able to check the entire two columns using a formula and have the worksheet count the no. of "model no.s" that are equal to X on a month by month basis, e.g. Jan-08, Feb-08, Mar-08 e.g. all model numbers that are equal to EC80 during the month of Jan.. I know I probably need to be using multiple IF statements but I'm at a complete loss on how to do this... maybe something like where A = Date Column where B = Model Column =IF(A:A01/01/08<31/01/08,COUNTIF(B:B,"EC80"),) although this doesn't work Any help much appreciated! Thanks Jon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a range of cells in a column equal to another cell | New Users to Excel | |||
Count number of values equal to MAX of a column | Excel Discussion (Misc queries) | |||
2 column lookup - match to date range | Excel Worksheet Functions | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Count cells based on date range in another column | New Users to Excel |