From: manfred3 on 20 Mar 2010 16:51 Hi, I have a spreadsheet with "weeks in column A and "Daily Charges" in column R. [see below] col A col R Week 1 Week 1 20 Week 1 week 2 week 2 How do I say calculate how many charges [col R] occur in "week 1" i.e. no of times there is a value in "col R" for week 1. What would I use if the no. of rows is 250 or if it varies month on month. Thanks From: T. Valko on 20 Mar 2010 17:16 Maybe something like this... =SUMPRODUCT(--(A2:A250="Week 1"),--(R2:R250<>"")) If you're using Excel 2007... Assumes the cells in column R are either *EMPTY* or contain a visible entry. =COUNTIFS(A2:A250,"Week 1",R2:R250,"<>") -- Biff Microsoft Excel MVP "manfred3" wrote in message news:1d3bd3a3-2b67-4a13-87d7-1c47b31924c2(a)b7g2000yqd.googlegroups.com...> Hi, > > I have a spreadsheet with "weeks in column A and "Daily Charges" in > column R. [see below] > > col A col R > > Week 1 > Week 1 > 20 > Week 1 > week 2 > week 2 > > How do I say calculate how many charges [col R] occur in "week 1" > i.e. no of times there is a value in "col R" for week 1. > > What would I use if the no. of rows is 250 or if it varies month on > month. > > Thanks > >