Trying to develop equation

  • Thread starter Thread starter bike-board-hike
  • Start date Start date
B

bike-board-hike

I have two columns, one has variable data while the other is x/empty. I am
trying to count the number of "x" for a certain variable. Below is an
example of the set up:

Size Replace
12 x
12
12 x
18 x
18 x
18 x
24
24
24 x

The formula cells would equate to the total column below:

Size Total
12 2
18 3
24 1

Any help would be great, Thanks
 
I found this equation on contextures.com after the post, what is the
difference? They both seem to work properly.

=SUMPRODUCT(--($F$8:$F$207=12),--(I8:I207="x"))

Thanks
 
Back
Top