Prev: Variable Labor percentage based off of fixed sales +/-
Next: Warning when in another cell after entering a formula.
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" <manir.fareed(a)googlemail.com> 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
>
>


 | 
Pages: 1
Prev: Variable Labor percentage based off of fixed sales +/-
Next: Warning when in another cell after entering a formula.