Help with sum function

[Andreas]

Hi

I have a problem that I can't seem to solve.

This is the scenario:
I've got a report with values from one day containing of 24 lines, one
for each hour. In one column I've got average values and in one column
the time that the processes have been running that hour (from 0.0->1.0
hour).

Example:
.....A....B
1..23...0.2
2..34...0.8
3..12...0.0
4..14...0.3
5.SUM...1.3


I have this function right now in A5 (where I've written SUM):
=IF(ISERROR(SUM(B2:B5*C2:C5)*60)/C6*60)), "",
SUM(B2:B5*C2:C5)*60)/C6*60))
This is enterd as a array formula and works just fine.

The problem is that in column A sometimes can contain an error value
like #N/A!. In column A I've got this formula:
=IF(ISERROR([The_source]), "", [The_source])
[The_source] is the place I'm fetching the value from (a vlookup
funktion).

I've tried to fix the first formula by entering
IF(ISERROR(B2:B5),0,B2:B5) but it ain't working. Please help me...

Andreas

 

[Jonathan Rynd]

(e-mail address removed) (Andreas) wrote in

=IF(ISERROR(SUM(B2:B5*C2:C5)*60)/C6*60)), "",
SUM(B2:B5*C2:C5)*60)/C6*60))

This formula refers to column C. You don't have a column C in the table you
posted. Could you please explain what "C" refers to?

 

[Jonathan Rynd]

(e-mail address removed) (Andreas) wrote in

The problem is that in column A sometimes can contain an error value

I've tried to fix the first formula by entering
IF(ISERROR(B2:B5),0,B2:B5) but it ain't working. Please help me...

Is it column A or column B that might have the error?

 

[Andreas]

Hi

I have a problem that I can't seem to solve.

This is the scenario:
I've got a report with values from one day containing of 24 lines, one
for each hour. In one column I've got average values and in one column
the time that the processes have been running that hour (from 0.0->1.0
hour).

Example:
....A....B
1..23...0.2
2..34...0.8
3..12...0.0
4..14...0.3
5.SUM...1.3


I have this function right now in A5 (where I've written SUM):
=IF(ISERROR(SUM(B2:B5*C2:C5)*60)/C6*60)), "",
SUM(B2:B5*C2:C5)*60)/C6*60))
This is enterd as a array formula and works just fine.

The problem is that in column A sometimes can contain an error value
like #N/A!. In column A I've got this formula:
=IF(ISERROR([The_source]), "", [The_source])
[The_source] is the place I'm fetching the value from (a vlookup
funktion).

I've tried to fix the first formula by entering
IF(ISERROR(B2:B5),0,B2:B5) but it ain't working. Please help me...

Andreas

As pointed out I've mixed up a few names here. In the formula B is
really A and C is B. I had an extra column first in my example but
removed it, and forgot to update the columns...

 

[Jonathan Rynd]

(e-mail address removed) (Andreas) wrote in @posting.google.com:

As pointed out I've mixed up a few names here. In the formula B is
really A and C is B. I had an extra column first in my example but
removed it, and forgot to update the columns...

Could you post the whole thing again, this time with the proper column
names?