conditional sums and multiple criteria
 

Please help: I'm working on an award tracking system for individual girl scouts and a summary sheet that lists if each scout earned an award and the date it was awarded. I'm trying to calculate how many awards to purchase and need to count the number of completed awards only if date awarded field is blank. I've tried COUNTA, SUMIF, and keep coming up with errors. Do I need to combine functions? If so, how do I do this on the function bar? I'm a newbie and am not yet ready to get into VBA. Thanks!

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

conditional sums and multiple criteria
 

To count the number of empty cells in the range B2:B10

=COUNTBLANK(B2:B10)

Biff

<SueC wrote in message ...
Please help: I'm working on an award tracking system for individual girl
scouts and a summary sheet that lists if each scout earned an award and
the date it was awarded. I'm trying to calculate how many awards to
purchase and need to count the number of completed awards only if date
awarded field is blank. I've tried COUNTA, SUMIF, and keep coming up with
errors. Do I need to combine functions? If so, how do I do this on the
function bar? I'm a newbie and am not yet ready to get into VBA. Thanks!

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com