Forum Discussion
Formula help, counting related
Date Cat Customer SP1 SP2 Stk # 5/31 6/24 Baker NM DH L6456 5/31 6/26 Northrup DH L6314 5/31 6/26 Rayner MD MVC L6316 5/31 6/16 Sangalis DG L6441 5/31...
Hi Lance,
If
- nothing depends on what is in SP1 ccolumn;
- you need only totals for each SP;
- totals are for entire table (not by time periods, category, etc)
you may calculate count of blank cells =COUNTBLANK() and non-blank cells =COUNTA() in SP2 column and multiply them accordingly on 1 and 0.5 for SP1, and on 0 and 0.5 for SP2.
The only point be sure empty cells in SP2 column are really empty, i.e. without spaces and special symbols. If doubt check with =ISBLANK(<cell>).