Help with sum function

A

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
 
J

Jonathan Rynd

[email protected] (Andreas) wrote in
=IF(ISERROR(SUM(B2:B5*C2:C5)*60)/C6*60)), "",
SUM(B2:B5*C2:C5)*60)/C6*60))
Click to expand...

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?
 
A

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


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...
 
J

Jonathan Rynd

[email protected] (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...
Click to expand...

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