the formula is for Row 3 cwhere the column you want added is G. I performs a
subtotal only when the data in a row doesn't equal the data in the next row.

=IF(G3<G4,COUNTIF(G:G,G3),"")

"Elizabeth" wrote:

I am trying to total the number of line items per ID# in a particular column
within a spreadsheet, as pictured below. I do not want to create subtotal
rows, nor do I want to work with levels. I've tried various things with the
IF, SUMIF and COUNTIF functions, to no avail. I am fairly new to all this
and would greatly appreciate any and all suggestions.

Thanks!


Number of Line Items per ID# Count ID#
1 1000
1 1000
3 1 1000
1 1 1001
1 1 1002
1 1 1003
1 1004
1 1004
1 1004
1 1004
1 1004
6 1 1004