I have the following Countif formula working but I wish to add many more columns to the function but excel says I can't do that. Is it possible or do I use another function? Thanks for all your help.
Mike
WORKS
=COUNTIF(Q21:Q128:R21:R128,"1-*")
DOES NOT WORK
=COUNTIF(Q21:Q128:R21:R128:V21:V128:W21:W128:AA21:AA128:AB21:AB128:AF21:AF128:AF21:AG128:AG21:AK128:AK21:AL128:AL21:AP128:AP21:AQ128:AQ21:AU128:AU21:AV128:AV21:AZ128:AZ128:BA128:BA128:BE128:BE128:BF128:BF128:BJ128:BJ128:BK128:BK128,"1-*")
Bookmarks