If the cell is not empty, then...

[SpookiePower]

I have a many rows of 12 cells where it is possible to write a number/
text in the cells.

I would like to be able to calculate how many of these cells, in one
row, that are different from empty,
and then multiplie this with the value 8,3

Like if 7 cells in one row are different from empty, then =SUM(7x8,3)

how can I do this ?

 

[Steve Dunn]

=counta(A1:L1)*8,3

 

[SpookiePower]

=counta(A1:L1)*8,3

Thanks, but it will not work for me.

If the cells from A1:L1 are empty, I get an error. If I start to write
something
in the cells, I get the same error.

 

[Steve Dunn]

What is the error?

Thanks, but it will not work for me.

If the cells from A1:L1 are empty, I get an error. If I start to write
something
in the cells, I get the same error.

 

[Parag Satpute]

Try the below formula to get the output you need,

=SUM(COUNTIF(A1:A12,"")*8,3)



SpookiePower wrote:

If the cell is not empty, then...
02-Jun-10

I have a many rows of 12 cells where it is possible to write a number
text in the cells

I would like to be able to calculate how many of these cells, in on
row, that are different from empty
and then multiplie this with the value 8,

Like if 7 cells in one row are different from empty, then =SUM(7x8,3

how can I do this ?

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
MSChart For VB.Net
http://www.eggheadcafe.com/tutorial...4dc6-9aa7-4f6246763650/mschart-for-vbnet.aspx

 

[Steve Dunn]

Did you mean to multiply by 8 then add 3, or to multiply by 8.3?

=counta(a1:l1)*8+3

=counta(a1:l1)*8.3

???