IF cell BLANK enter text

[rz6657]

I have a data tab with a column that has text but also has empty cells (blank cells). I need for each cell that has no value / empty to be replaced with the following text: "Blank" while ignoring the cells that do have values... I would do this manually but it has over 8k rows. Thanks.

Data starts at R5 (only that column R)

Added example file -

[AlKey]

Just out of curiosity, why do you want blank cells to say "Blank"?

[rz6657]

Each row has expense and capital totals. Where there is no vendor linked to the totals by row it will be an empty cell. However, I still need to quantify the empty cells into the overall grand totals - by placing "blank" I can then use that as a criteria to count using the SUMIFs formula

[FDibbins]

You could also use =""....

=sumifs(A:A,B:B,1,C:C="")

[AlKey]

You can also count blanks

=COUNTIF(A2:A7,"")

[rz6657]

I have multiple criteria: by year, by month, by project, by Vendor, etc...

[FDibbins]

Well you can still use the same method, with however many criteria you have. "No data" is a searchable criteria

[rz6657]

I don't need to count the blank cells. I need to sum the totals in column AB that have empty cell in column R...

For example: my sumifs formula will sum what's in column AB by PID, by Month and by Vendor Name (these are columns in the attached file) . However, if there is no Vendor name the formula in a different tab will not sum...

[rz6657]

It's not summing where cell is empty

[FDibbins]

=sumifs(y5:y43,r5:r43,"")
104719.93

[FDibbins]

Or this...
=SUMIFS($AB$5:$AB$43,$D$5:$D$43,"PID1",$N$5:$N$43,12013,$S$5:$S$43,"")
19056