Forum Discussion
Sum columns with blanks
hi
I have customers that score over months. Columnt with the monthly calculation is based on division of old season/current season sales and based on the percentage the score is calculated using the switch function. For some months (empty cells in below table) i do nt have the current season sales yet so the division returns blank.
In the SWITCH function one of the criteria says if this column is blank then return blank. but i would still like to sum it up as shown in the table below. For some reason I get emty cels also for customer A and B and not only for Customer D.
| customer | May Score | June Score | July Score | Total Score |
| a | 10 | 15 | 25 | |
| b | 20 | 20 | ||
| c | 10 | 5 | 20 | 35 |
| d |
Thank you for helping
1 Reply
Anonymous not fully clear what you are asking. Can you share sample data with expected output and current calculation you have.
