conditional sums and multiple criteria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a macro to change a value in a record 1
Hard to explain - multiple update fields query... 7
array and countif help! 7
Multiple CountIF in 1 function 1
find minimum of range based on multiple criteria 3
Too Complex Sum 2
Conditional IF 1
Question along the same lines 2

Top