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

Maybe

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

Mike

"bike-board-hike" wrote:

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

Adjust your ranges accordingly (they both must be the same size)...

=SUMPRODUCT((A2:A1000=12)*(B2:B1000="x"))

Just change the 12 as needed (or use a cell reference).

--
Rick (MVP - Excel)


"bike-board-hike" wrote in
message ...
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




"Mike H" wrote:

Maybe

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

Mike

"bike-board-hike" wrote:

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

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


"bike-board-hike" wrote in message
...
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




"Mike H" wrote:

Maybe

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

Mike

"bike-board-hike" wrote:

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

Thanks for the links, they were really helpful

"Bernard Liengme" wrote:

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


"bike-board-hike" wrote in message
...
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




"Mike H" wrote:

Maybe

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

Mike

"bike-board-hike" wrote:

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