Comparison filters effecting sum

Hi Anonymous ,

To avoid making the calculation when any column is blank, you can use the IF statement below to check if there are blanks before the sum. If there is any blank, them the calculation will return BLANK (or you can assign a specific value to these cases):

Pr2-Pr1 =
IF(
ISBLANK(KS3[Prof Y8Pr1]) || ISBLANK(KS3[Prof Y8Pr2]),
BLANK(),
KS3[Prof Y8Pr2] - KS3[Prof Y8Pr1]
)

This formula basically check if Pr1 OR Pr2 are blanks, if any of them is blank, them it returns blank, otherwise it returns the Pr2-Pr1.

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️or giving it a kudoe 👍

Thanks!
Best regards,
Joao Ribeiro