CountA function to Count Blanks

		Microsoft Office Forums > Microsoft Excel > Excel
CountA function to Count Blanks

#10

02-10-2015, 10:06 PM

macropod

Windows 7 64bit CountA function to Count Blanks

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,359

You could try:
=SUMPRODUCT((Sheet1!$H2:$H264="")*(Sheet1!$I2:$I26 4="")*(Sheet1!$J2:$J264=""))

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Counting Blanks in 1 Column and Non-Blanks in Another	dogwood705	Excel	4	02-07-2015 08:45 AM
Function to Count Data	bdavidson22	Excel	0	12-19-2014 11:48 AM
COUNTA function returns incorrect value	joeller	Excel	2	10-16-2012 05:37 AM
Use of MIN and count function together	khokababu	Excel	0	02-22-2012 09:40 AM
fill blanks in box	keevitaja	Word	1	05-23-2011 06:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:37 PM.