Count number of cells in column per month

**lamdl** · 01-09-2014, 05:47 PM

Hey guys,

I would like to count the number of cells that contains a date in each month.

I have attached my workbook here: Book2.xlsx

**alansidman** · 01-09-2014, 06:02 PM

Use the sumproduct as shown in attached.

**lamdl** · 01-09-2014, 07:07 PM

Thanks a lot! that worked.

I would also like to average the values in column C associated with each month. So each month would have an average associated with it.

workbook BOOK 5.xlsx

Can you help me out with this as well?

**FDibbins** · 01-09-2014, 07:56 PM

Try this in F2, copied down...
=SUMPRODUCT(--(B$2:B$132<>""),--(MONTH(B$2:B$132)=D2)*($C$2:$C$132))/E2

**lamdl** · 01-10-2014, 04:25 PM

Originally Posted by FDibbins

Try this in F2, copied down...
=SUMPRODUCT(--(B$2:B$132<>""),--(MONTH(B$2:B$132)=D2)*($C$2:$C$132))/E2

That seems to work. However, if there is a formula at the bottom of column B and C that yield a "", the formula breaks.

new workbook: BOOK 6.xlsx

B/C:133 have a formula =""

I will need the formula in column E to work if there is a formula that yields a "" in column B and C.

I really appreciate your help!

Count number of cells in column per month

LinkBack

Thread Tools

Rate This Thread

Display

Count number of cells in column per month

Re: Count number of cells in column per month

Re: Count number of cells in column per month

Re: Count number of cells in column per month

Re: Count number of cells in column per month

Thread Information

Users Browsing this Thread

Similar Threads

Count number of dates in a column occuring in a specific month and specific year

Count number of networkdays for each month in a multi month period

[SOLVED] Count the number cells > 0 for each day of the month.

[SOLVED] count the number of populated cells in column N based on data in column D

Count number of cells of a particular month in a column of dates

Bookmarks

Bookmarks

Posting Permissions