empty cell sum?

verge · May 24th, 2002, 01:55 PM

Ok-- i have several colums of data, with matching information for completed things.

So to explain-- it looks like this

date name datecomplete
12 joe 05/25/2002
13 pete
14 matt
14 matt

how can I compile the # of finished(ones with dates)
and compile the # of unfinished ones,
By Name-- so it looks like this

peteincomplete = 1
mattincomplete = 2

I searched the forum for a while,
but didn't see any queries like mine.

Thank you for any help you can give

Aladin Akyurek · May 24th, 2002, 01:59 PM

=SUMPRODUCT((B2:B5="matt")*(LEN(C2:C5)=0))

verge · May 24th, 2002, 02:05 PM

Thanks a lot~!

I'm off to go work on it

much appreciated

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 24th, 2002, 01:55 PM	#1
verge New Member Join Date: May 2002 Posts: 2	Ok-- i have several colums of data, with matching information for completed things. So to explain-- it looks like this date name datecomplete 12 joe 05/25/2002 13 pete 14 matt 14 matt how can I compile the # of finished(ones with dates) and compile the # of unfinished ones, By Name-- so it looks like this peteincomplete = 1 mattincomplete = 2 I searched the forum for a while, but didn't see any queries like mine. Thank you for any help you can give

May 24th, 2002, 01:59 PM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	=SUMPRODUCT((B2:B5="matt")*(LEN(C2:C5)=0))

May 24th, 2002, 02:05 PM	#3
verge New Member Join Date: May 2002 Posts: 2	Thanks a lot~! I'm off to go work on it much appreciated