Hi all ... First post for me, and apologies if this has been solved elsewhere here. I have looked, but don't seem to find a solution, thus my post ...

I have two columns, the first for "Serial Number" and the second for "Device Warranty", as per the attached image.

As I would like my spreadsheet to be future proof, and thus allow as many entries as time will add to it, I would like to count the number of blank cells in the "Device Warranty" column, but only count it if the cell to its left, "Serial Number" is not blank.

In other words, I would like to know how many devices I have without a warranty.

I have searched and trawled forums, bashed my head (still have the bruise) and I just can't seem to get this right ...

Any help?

Thanks!

Adam

excel.GIF