My Goal: Count the number of cells in a range that are formatted as a percentage.

My workaround: Using the formula =CELL("format", A1) I can duplicate a row with a series of format types (ie. P0, G, P0, N, P0) etc. Then I used the formula =COUNTIF(B1:B10,"p0") to count the number of times the format P0 shows up.

My Plea: Can someone show me a way to evaluate the cell format within the COUNTIF formula to combine the two functions. I just can't get my head around how to apply the CELL function to the range.

Thanks.