| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
COUNTIF within date ranges
Hi,
I wish to find out how many times"1.8" appears (column 'J') each week this year using dates in column 'B'. I have a formula which returns the total number of entries for a given week, but I wish to split this down into its constituent parts for each week. Current formula: SUMPRODUCT(--(1+INT((B$8:B$9997-(DATE(YEAR(B$8:B$9997),1,2)-WEEKDAY(DATE(YEAR(B$8:B$9997),1,1))))/7)=22)) This returns the total no. of entries for week 22 Any ideas? -- tia Jock |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif with Dynamic date ranges. | Excel Worksheet Functions | |||
| countif with non-continous ranges | Excel Worksheet Functions | |||
| Countif between ranges | Excel Discussion (Misc queries) | |||
| CountIF and changing ranges | Excel Worksheet Functions | |||
| COUNTIF criteria using date ranges? | Excel Worksheet Functions | |||
Threaded Mode
