I'm trying to create a COUNTIF function for multiple columns and one criteria.

For example, the range is column X, AD, AJ, AP, and AV with the criteria if the cell says "Pending." I'm trying to create a summary to count how many cells in each of those columns says pending. Also, the summary is on a different worksheet tab than the data. I've tried a few different formulas, but none of them seem to work.

Any ideas?

I'm still learning how to use all the functions in Excel, so bear with me!

Thanks for the help!

Kat