Something like COUNTIF but can take multiple ranges?

Hello,

I want to use the function COUNTIF through a spreadsheet but it won't allow me to use it over more than one range. The only way I can get it to work is if I retype the whole function for each range. There are gaps and and headers in the spreadsheet in which I don't want to include the function and that is causing problems with the cells that I do want to use it for.

Example of what works: =COUNTIF('Book1'!G4:G51, "Complete")
Example of what I want but does not work =COUNTIF('Book1'!G4:G51,G53:G70, "Complete")

Is there another function or would something like this require VBA code?

Thanks and I can provide more detail if needed.