Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi i have a worksheet with the following set up
col A = date col B = x what I want to do is, count all items within a certain month and b column is not empty. ex. count all items in column A which are in november and that column b is not empty. I can count the number of items in november with this formula =SUMPRODUCT(-(MONTH(a10:a500)=11),-ISNUMBER((a10:a500))) but how do I only count the ones which there is something written in the b column for that month. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
calling a new function Excel gives me #NAME? | Excel Worksheet Functions | |||
Excel 2003 Slow Function Argument Window | Excel Discussion (Misc queries) | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Simplify Vlookup function in Excel | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) |