counting w/subtotals

[C-MONEY]

I have a sheet titled subtotals which has subtotals for
several people and I now want to insert a formula to count
the total number of accounts for each person and place
that number in the same row as the person's subtotal. For
instance there are four entries for Smith, John (column
D). In the row for Smith, John, total I want to insert
the counting formula. I tried using COUNTIF(subtotals!
D35000 = "SMITH, JOHN") but get an error message saying
there aren't enough arguments. After I click ok JOHN" is
highlighted as if there is a problem with that. I also
got the same problem with SUMPRODUCT. I have a feeling
I'm making a dumb mistake but I can't figure this out.

 

[John Michl]

Try replacing the = sign with a comma. There are two parts to countif. The
first is the range to look at and the second is the criteria. The formula
assumes "=" so you only need to add greater than and less then signs when
needed.

- John Michl

 

[RagDyeR]

If you're using:
<Data> <Subtotals>,
There is a count function built into the "Subtotal" dialog window,
Where you even have the choice of which column to place the count into.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have a sheet titled subtotals which has subtotals for
several people and I now want to insert a formula to count
the total number of accounts for each person and place
that number in the same row as the person's subtotal. For
instance there are four entries for Smith, John (column
D). In the row for Smith, John, total I want to insert
the counting formula. I tried using COUNTIF(subtotals!
D35000 = "SMITH, JOHN") but get an error message saying
there aren't enough arguments. After I click ok JOHN" is
highlighted as if there is a problem with that. I also
got the same problem with SUMPRODUCT. I have a feeling
I'm making a dumb mistake but I can't figure this out.

 

[Guest]

Got it to work. Thanks a lot

-----Original Message-----
Try replacing the = sign with a comma. There are two parts to countif. The
first is the range to look at and the second is the criteria. The formula
assumes "=" so you only need to add greater than and less then signs when
needed.

- John Michl







.