| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding multiple sums w/ different criteria | Excel Discussion (Misc queries) | |||
| Conditional Formatting, Multiple Criteria | Excel Discussion (Misc queries) | |||
| conditional formatting, multiple criteria | Excel Worksheet Functions | |||
| Multiple Criteria for Conditional Formatting | Excel Worksheet Functions | |||
| Conditional Lookup on Multiple Criteria | Excel Worksheet Functions | |||
Linear Mode
