Countif problem

J

Jim

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")
 
D

Dave Peterson

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

or

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