ExcelBanter - assign value to text

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - assign value to text (https://www.excelbanter.com/excel-worksheet-functions/49818-assign-value-text.html)

shellie

assign value to text

need to count # of times x appears in column and have a value of 1..
then need to be able to have sum of "x's" in cell range C4:c156

Bob Phillips

=SUMPRODUCT(--(A2:A200="x"),--(B2:B200=1))

=COUNTIF(C4:C156,"x")

--
HTH

Bob Phillips

"shellie" wrote in message
...
need to count # of times x appears in column and have a value of 1..
then need to be able to have sum of "x's" in cell range C4:c156

All times are GMT +1. The time now is 11:49 AM.