If the cell is not empty, then...

  • Thread starter Thread starter SpookiePower
  • Start date Start date
S

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 ?
 
=counta(A1:L1)*8,3
Click to expand...


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.
 
What is the error?

SpookiePower said:
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.
Click to expand...
 
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
 
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

???
 
Back
Top