“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

i need to adjust a formula to not count blank cells

Solved by Z. J. in 13 mins

When using an IF-Than Formula, how do you get the False Value to Turn a Cell Blank? I have been using "", but then it registers in COUNT Formulas. Is there a False Result to just keep the Cell Blank, so it does not mess up other formulas performing on it?

Solved by B. A. in 23 mins

Hi,
I use the following formulas to count the number of days between two dates, and if one column is blank, to show a blank cell, otherwise the number of days, on in a nearby cell "Not Received".
=IF(H197="","",IF(C197="",TODAY(),C197)-H197)
=IF(H197="","Not Received","")
I would like to show something like "Not Received" if the cell is returned blank. I have got this working in an adjacent cell, but would like to combine the two formulas to show in the same cell.
Hope this makes sense?
Please could someone help me combine the two formulas to show the desired result, or is it not possible?
Kind regards,
Stephen

Solved by S. J. in 29 mins

I want to count how many rows have not had any action taken yet but are not yet Overdue. So my row G from cell G3 to G102 need to be blank and cell F3 to F102 need to be blank. I don't want it to count any rows that are blank (which naturally have the G and F columns blank.
I want to count how many cells have F and G columns blank but still have text in column B which means that there is a task in that row. I've tried a few different formulas but they won't work.

Solved by I. H. in 29 mins

0 blank =IF(D4>C4,1,"")
Why does the 3rd cell give me 1 when the blank cell is not greater than the 0 cell?

Solved by G. H. in 26 mins