Autosum

[BrianOES]

Hi,

I am trying to create a worksheet with, for example 3 columns A, B & C, I will autosum Columns A & B and their totals will divide as a percentage in column C.

When there is no data in some column B cells, this would create a incorrect percentage in column C, how do I combat this?

[#2]

@BrianOES 

Blank cells are considered as zeroes when SUM. To exclude from C values where B is blank

=SUM($B$1:$B$10)/SUMPRODUCT(($B$1:$B$10<>"")*$C$1:$C$10)

[#3]

@Sergei BaklanThank you for your reply, I was trying to not autosum the data in, say, A3 until data was entered into B3.

[#4 · Accepted solution]

@BrianOES 

When it's like

=SUMPRODUCT(($B$1:$B$10<>"")*$A$1:$A$10)

to sum in column A

[#5]

@Sergei BaklanThank you very much, that did it.