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