Trying to develop equation

[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

 

[Mike H]

Maybe

=SUMPRODUCT((A1:A19=12)*(B1:B19="X"))

Mike

 

[bike-board-hike]

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

 

[Bernard Liengme]

For more details on SUMPRODUCT
Bob Phillips
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

J.E McGimpsey (explains the double negation)
http://mcgimpsey.com/excel/formulae/doubleneg.html
best wishes

 

[bike-board-hike]

Thanks for the links, they were really helpful

For more details on SUMPRODUCT
Bob Phillips
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

J.E McGimpsey (explains the double negation)
http://mcgimpsey.com/excel/formulae/doubleneg.html
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email