Count blank cells in a column

Dalia123

New Member
Joined
Nov 29, 2005
Messages
20
I have two sheets.Sheet one has the total values of Sheet 2.
I want to do a check if cell in column A (sheet 2) has a value to check if the corresponding B (sheet2) cell has a value. And give me a 'countblank' for the blank B(Sheet2) cells. and Insert this value in a cell (C3) in Sheet 1.

Thanks for any help out there,
Dalia
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

tactps

Well-known Member
Joined
Jan 20, 2004
Messages
3,459
How about:
=SUMPRODUCT(--(A1:A20<>0),--(Sheet2!A1:A20=0))
 

Watch MrExcel Video

Forum statistics

Threads
1,119,128
Messages
5,576,253
Members
412,709
Latest member
Rishu
Top