ExcelBanter - Countif problem

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

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

- - Countif problem (https://www.excelbanter.com/excel-discussion-misc-queries/183579-countif-problem.html)

Jim[_6_]

Countif problem

I am using the formula below to find the letter D in a sheet.
I would like to also look for Dc as well in the same sheet.
Can this formula be easily modified?
Thanks
Jim

=COUNTIF(E3:AP148,"D")

Dave Peterson

Countif problem

=COUNTIF(E3:AP148,"D") + COUNTIF(E3:AP148,"Dc")

or

=sum(COUNTIF(E3:AP148,{"D","DC"}))

Jim wrote:

I am using the formula below to find the letter D in a sheet.
I would like to also look for Dc as well in the same sheet.
Can this formula be easily modified?
Thanks
Jim

=COUNTIF(E3:AP148,"D")

--

Dave Peterson

Jim[_6_]

Countif problem

Hello Dave,
Many thanks, both work fine.
Regards
Jim

"Dave Peterson" wrote in message
...
=COUNTIF(E3:AP148,"D") + COUNTIF(E3:AP148,"Dc")

or

=sum(COUNTIF(E3:AP148,{"D","DC"}))

Jim wrote:

I am using the formula below to find the letter D in a sheet.
I would like to also look for Dc as well in the same sheet.
Can this formula be easily modified?
Thanks
Jim

=COUNTIF(E3:AP148,"D")

--

Dave Peterson

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