I require a formula to count the number of times a word appears in a range and out of this range I need to count the number of blank spaces in another range with reference only to the first formula.

These are my two formulas that work separately however I need the total number together. =COUNTIF(G2:G473,G476) =COUNTBLANK(D2:D472)

So if the first formual is requal to 50 I want to know how many of those 50 from column G have a blank space in row D.

`COUNTIFS`

instead of`COUNTIF`

. Make sure the size of the two ranges is equal: in the example you give you have one range ending at row 472 and the other at row 473.