conditional sums and multiple criteria

  • Thread starter Thread starter SueC
  • Start date Start date
S

SueC

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
 
Back
Top