Nested countif,or
I am having trouble writing a nested function. I want a range of cells (A1 to
D1) to be counted if they contain the letter X or C. Thank you. |
Nested countif,or
How about:
=countif(a1:d1,"X")+countif(a1:d1,"C") Regards, Fred. "letsrolldog" wrote in message ... I am having trouble writing a nested function. I want a range of cells (A1 to D1) to be counted if they contain the letter X or C. Thank you. |
Nested countif,or
One mo
=SUM(COUNTIF(A1:D1,{"X","C"})) letsrolldog wrote: I am having trouble writing a nested function. I want a range of cells (A1 to D1) to be counted if they contain the letter X or C. Thank you. -- Dave Peterson |
All times are GMT +1. The time now is 10:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com