ExcelBanter - counting the number of times value of "x" appears in a row

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - counting the number of times value of "x" appears in a row (https://www.excelbanter.com/excel-discussion-misc-queries/102098-counting-number-times-value-x-appears-row.html)

Hugh

counting the number of times value of "x" appears in a row

I need to count the number of times the value of "x" appears in a row.
Cannot figure out how to do it.

VBA Noob

counting the number of times value of "x" appears in a row

=COUNTIF(1:1,"X")

or

=SUMPRODUCT(--(1:1="x"))

VBA Noob

--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566363

Hugh

counting the number of times value of "x" appears in a row

Thank you very much!

"VBA Noob" wrote:

=COUNTIF(1:1,"X")

or

=SUMPRODUCT(--(1:1="x"))

VBA Noob

--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566363

All times are GMT +1. The time now is 06:39 AM.