Variance for none blank cells only

Column A has Load Weights
Column B has Unload Weights

I need an equation/formula to calculate the total variance between Column A minus Column B, but only when Column B has a number entered (If blank than do not add this to the total as the variance is unknown).


In C1 I need the Sum of all variances from Column A - Column B (If not blank)


Thank you for the help!

If I understand what you want, maybe this...

Data Range

	A	B	C	D
1	5	4		5
2	10	8
3	22
4	10	10
5	5	3
6	------	------	------	------

This formula entered in D1:

=SUMPRODUCT(--(B1:B5<>""),A1:A5-B1:B5)

You're welcome. Thanks for the feedback!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.