Excel formula, nested CountIF's?

[Ben171]

Hi there, i have the following column H, there are 2000 rows in this column. I would like to do a formula which counts the total number of rows that are "underpaying" and the total that are "overpaying"

I created the following formula

= "Overpaying: " &COUNTIF(H4:H2052,"OVERPAYING")

This works well, but how can i include the underpaying in this formula so it displays both in one cell? if possible

 

[Fluff]

How about

= "Overpaying: " &COUNTIF(H4:H2052,"OVERPAYING") & " Underpaying: "&COUNTIF(H4:H2052,"underpaying")

 

[Ben171]

How about

= "Overpaying: " &COUNTIF(H4:H2052,"OVERPAYING") & " Underpaying: "&COUNTIF(H4:H2052,"underpaying")

that worked perfectly. I didn't know could just do '&' and then do another formula. That's great thank you!

 

[Fluff]

You're welcome & thanks for the feedback.