#1   Report Post  
Micayla Bergen
 
Posts: n/a
Default formula not working

= SUM('A & E John Super'!$P$4:$P$39)/SUM('A & E John Super'!$L$4:$Q$39)
where =IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,
FALSE))),"",I12&J12) is on the A & E John Super worksheet
there are values on the AEJohn worksheet but they are not adding up on the
other worksheet. do i need another reference or ' or something?
thanks
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

This formula returns text:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",I12&J12)

Did you mean i12+j12 (to sum those numbers).

If i12=123 and j12=456, then i12&j12 = 123456. But i12+j12=579.


Micayla Bergen wrote:

= SUM('A & E John Super'!$P$4:$P$39)/SUM('A & E John Super'!$L$4:$Q$39)
where =IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,
FALSE))),"",I12&J12) is on the A & E John Super worksheet
there are values on the AEJohn worksheet but they are not adding up on the
other worksheet. do i need another reference or ' or something?
thanks


--

Dave Peterson
  #3   Report Post  
Micayla Bergen
 
Posts: n/a
Default

yes i want to sum the numbers in the cells, not combine them. so i changed
the & to + but got a value error.

"Dave Peterson" wrote:

This formula returns text:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",I12&J12)

Did you mean i12+j12 (to sum those numbers).

If i12=123 and j12=456, then i12&j12 = 123456. But i12+j12=579.


Micayla Bergen wrote:

= SUM('A & E John Super'!$P$4:$P$39)/SUM('A & E John Super'!$L$4:$Q$39)
where =IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,
FALSE))),"",I12&J12) is on the A & E John Super worksheet
there are values on the AEJohn worksheet but they are not adding up on the
other worksheet. do i need another reference or ' or something?
thanks


--

Dave Peterson

  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

Do you get the error when you put:
=i12+j12
in a cell by itself (just for testing purposes).

For this expression to work, both I12 and J12 have to be numeric (or empty).

If there's a chance you have text in those cells, maybe:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",sum(I12,J12))

would work better.

===
Be aware that if either I12 or J12 has an error in it, then you'll get an error
returned for the sum.


Micayla Bergen wrote:

yes i want to sum the numbers in the cells, not combine them. so i changed
the & to + but got a value error.

"Dave Peterson" wrote:

This formula returns text:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",I12&J12)

Did you mean i12+j12 (to sum those numbers).

If i12=123 and j12=456, then i12&j12 = 123456. But i12+j12=579.


Micayla Bergen wrote:

= SUM('A & E John Super'!$P$4:$P$39)/SUM('A & E John Super'!$L$4:$Q$39)
where =IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,
FALSE))),"",I12&J12) is on the A & E John Super worksheet
there are values on the AEJohn worksheet but they are not adding up on the
other worksheet. do i need another reference or ' or something?
thanks


--

Dave Peterson


--

Dave Peterson
  #5   Report Post  
Micayla Bergen
 
Posts: n/a
Default

only one cell will have a value because it denotes which type of product it
is, but im not sure how to say look in either one so ive said both.

yes i get the error when by itself

"Dave Peterson" wrote:

Do you get the error when you put:
=i12+j12
in a cell by itself (just for testing purposes).

For this expression to work, both I12 and J12 have to be numeric (or empty).

If there's a chance you have text in those cells, maybe:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",sum(I12,J12))

would work better.

===
Be aware that if either I12 or J12 has an error in it, then you'll get an error
returned for the sum.


Micayla Bergen wrote:

yes i want to sum the numbers in the cells, not combine them. so i changed
the & to + but got a value error.

"Dave Peterson" wrote:

This formula returns text:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",I12&J12)

Did you mean i12+j12 (to sum those numbers).

If i12=123 and j12=456, then i12&j12 = 123456. But i12+j12=579.


Micayla Bergen wrote:

= SUM('A & E John Super'!$P$4:$P$39)/SUM('A & E John Super'!$L$4:$Q$39)
where =IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,
FALSE))),"",I12&J12) is on the A & E John Super worksheet
there are values on the AEJohn worksheet but they are not adding up on the
other worksheet. do i need another reference or ' or something?
thanks

--

Dave Peterson


--

Dave Peterson



  #6   Report Post  
Dave Peterson
 
Posts: n/a
Default

How about the sum(i12,j12) suggestion--do you get an error then?

Micayla Bergen wrote:

only one cell will have a value because it denotes which type of product it
is, but im not sure how to say look in either one so ive said both.

yes i get the error when by itself

"Dave Peterson" wrote:

Do you get the error when you put:
=i12+j12
in a cell by itself (just for testing purposes).

For this expression to work, both I12 and J12 have to be numeric (or empty).

If there's a chance you have text in those cells, maybe:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",sum(I12,J12))

would work better.

===
Be aware that if either I12 or J12 has an error in it, then you'll get an error
returned for the sum.


Micayla Bergen wrote:

yes i want to sum the numbers in the cells, not combine them. so i changed
the & to + but got a value error.

"Dave Peterson" wrote:

This formula returns text:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",I12&J12)

Did you mean i12+j12 (to sum those numbers).

If i12=123 and j12=456, then i12&j12 = 123456. But i12+j12=579.


Micayla Bergen wrote:

= SUM('A & E John Super'!$P$4:$P$39)/SUM('A & E John Super'!$L$4:$Q$39)
where =IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,
FALSE))),"",I12&J12) is on the A & E John Super worksheet
there are values on the AEJohn worksheet but they are not adding up on the
other worksheet. do i need another reference or ' or something?
thanks

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
  #7   Report Post  
Micayla Bergen
 
Posts: n/a
Default

yes

"Dave Peterson" wrote:

How about the sum(i12,j12) suggestion--do you get an error then?

Micayla Bergen wrote:

only one cell will have a value because it denotes which type of product it
is, but im not sure how to say look in either one so ive said both.

yes i get the error when by itself

"Dave Peterson" wrote:

Do you get the error when you put:
=i12+j12
in a cell by itself (just for testing purposes).

For this expression to work, both I12 and J12 have to be numeric (or empty).

If there's a chance you have text in those cells, maybe:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",sum(I12,J12))

would work better.

===
Be aware that if either I12 or J12 has an error in it, then you'll get an error
returned for the sum.


Micayla Bergen wrote:

yes i want to sum the numbers in the cells, not combine them. so i changed
the & to + but got a value error.

"Dave Peterson" wrote:

This formula returns text:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",I12&J12)

Did you mean i12+j12 (to sum those numbers).

If i12=123 and j12=456, then i12&j12 = 123456. But i12+j12=579.


Micayla Bergen wrote:

= SUM('A & E John Super'!$P$4:$P$39)/SUM('A & E John Super'!$L$4:$Q$39)
where =IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,
FALSE))),"",I12&J12) is on the A & E John Super worksheet
there are values on the AEJohn worksheet but they are not adding up on the
other worksheet. do i need another reference or ' or something?
thanks

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

  #8   Report Post  
Dave Peterson
 
Posts: n/a
Default

What's in I12?
What's in J12?



Micayla Bergen wrote:

yes

"Dave Peterson" wrote:

How about the sum(i12,j12) suggestion--do you get an error then?

Micayla Bergen wrote:

only one cell will have a value because it denotes which type of product it
is, but im not sure how to say look in either one so ive said both.

yes i get the error when by itself

"Dave Peterson" wrote:

Do you get the error when you put:
=i12+j12
in a cell by itself (just for testing purposes).

For this expression to work, both I12 and J12 have to be numeric (or empty).

If there's a chance you have text in those cells, maybe:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",sum(I12,J12))

would work better.

===
Be aware that if either I12 or J12 has an error in it, then you'll get an error
returned for the sum.


Micayla Bergen wrote:

yes i want to sum the numbers in the cells, not combine them. so i changed
the & to + but got a value error.

"Dave Peterson" wrote:

This formula returns text:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",I12&J12)

Did you mean i12+j12 (to sum those numbers).

If i12=123 and j12=456, then i12&j12 = 123456. But i12+j12=579.


Micayla Bergen wrote:

= SUM('A & E John Super'!$P$4:$P$39)/SUM('A & E John Super'!$L$4:$Q$39)
where =IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,
FALSE))),"",I12&J12) is on the A & E John Super worksheet
there are values on the AEJohn worksheet but they are not adding up on the
other worksheet. do i need another reference or ' or something?
thanks

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
  #9   Report Post  
Micayla Bergen
 
Posts: n/a
Default

I12is =IF(G4=0,H4*D4, "")
J12 is =IF(G4=1,H4*D4, "")
G4 is =IF(ISERROR((VLOOKUP(A4,'Model Portfolio'!$C$6:$C$50,1, FALSE))),0,1)
H4 is a vlookup
D4 is a manually input number

"Dave Peterson" wrote:

What's in I12?
What's in J12?



Micayla Bergen wrote:

yes

"Dave Peterson" wrote:

How about the sum(i12,j12) suggestion--do you get an error then?

Micayla Bergen wrote:

only one cell will have a value because it denotes which type of product it
is, but im not sure how to say look in either one so ive said both.

yes i get the error when by itself

"Dave Peterson" wrote:

Do you get the error when you put:
=i12+j12
in a cell by itself (just for testing purposes).

For this expression to work, both I12 and J12 have to be numeric (or empty).

If there's a chance you have text in those cells, maybe:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",sum(I12,J12))

would work better.

===
Be aware that if either I12 or J12 has an error in it, then you'll get an error
returned for the sum.


Micayla Bergen wrote:

yes i want to sum the numbers in the cells, not combine them. so i changed
the & to + but got a value error.

"Dave Peterson" wrote:

This formula returns text:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",I12&J12)

Did you mean i12+j12 (to sum those numbers).

If i12=123 and j12=456, then i12&j12 = 123456. But i12+j12=579.


Micayla Bergen wrote:

= SUM('A & E John Super'!$P$4:$P$39)/SUM('A & E John Super'!$L$4:$Q$39)
where =IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,
FALSE))),"",I12&J12) is on the A & E John Super worksheet
there are values on the AEJohn worksheet but they are not adding up on the
other worksheet. do i need another reference or ' or something?
thanks

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

  #10   Report Post  
Dave Peterson
 
Posts: n/a
Default

What does I12 evaluate to?
What does J12 evaluate to?



Micayla Bergen wrote:

I12is =IF(G4=0,H4*D4, "")
J12 is =IF(G4=1,H4*D4, "")
G4 is =IF(ISERROR((VLOOKUP(A4,'Model Portfolio'!$C$6:$C$50,1, FALSE))),0,1)
H4 is a vlookup
D4 is a manually input number

"Dave Peterson" wrote:

What's in I12?
What's in J12?



Micayla Bergen wrote:

yes

"Dave Peterson" wrote:

How about the sum(i12,j12) suggestion--do you get an error then?

Micayla Bergen wrote:

only one cell will have a value because it denotes which type of product it
is, but im not sure how to say look in either one so ive said both.

yes i get the error when by itself

"Dave Peterson" wrote:

Do you get the error when you put:
=i12+j12
in a cell by itself (just for testing purposes).

For this expression to work, both I12 and J12 have to be numeric (or empty).

If there's a chance you have text in those cells, maybe:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",sum(I12,J12))

would work better.

===
Be aware that if either I12 or J12 has an error in it, then you'll get an error
returned for the sum.


Micayla Bergen wrote:

yes i want to sum the numbers in the cells, not combine them. so i changed
the & to + but got a value error.

"Dave Peterson" wrote:

This formula returns text:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",I12&J12)

Did you mean i12+j12 (to sum those numbers).

If i12=123 and j12=456, then i12&j12 = 123456. But i12+j12=579.


Micayla Bergen wrote:

= SUM('A & E John Super'!$P$4:$P$39)/SUM('A & E John Super'!$L$4:$Q$39)
where =IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,
FALSE))),"",I12&J12) is on the A & E John Super worksheet
there are values on the AEJohn worksheet but they are not adding up on the
other worksheet. do i need another reference or ' or something?
thanks

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


  #11   Report Post  
Micayla Bergen
 
Posts: n/a
Default

in row A I12 is $10821.00, J12 is nothing, in row B I12 is nothing and J12 is
5430 but there is no pattern to which is blank on which row.

"Dave Peterson" wrote:

What does I12 evaluate to?
What does J12 evaluate to?



Micayla Bergen wrote:

I12is =IF(G4=0,H4*D4, "")
J12 is =IF(G4=1,H4*D4, "")
G4 is =IF(ISERROR((VLOOKUP(A4,'Model Portfolio'!$C$6:$C$50,1, FALSE))),0,1)
H4 is a vlookup
D4 is a manually input number

"Dave Peterson" wrote:

What's in I12?
What's in J12?



Micayla Bergen wrote:

yes

"Dave Peterson" wrote:

How about the sum(i12,j12) suggestion--do you get an error then?

Micayla Bergen wrote:

only one cell will have a value because it denotes which type of product it
is, but im not sure how to say look in either one so ive said both.

yes i get the error when by itself

"Dave Peterson" wrote:

Do you get the error when you put:
=i12+j12
in a cell by itself (just for testing purposes).

For this expression to work, both I12 and J12 have to be numeric (or empty).

If there's a chance you have text in those cells, maybe:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",sum(I12,J12))

would work better.

===
Be aware that if either I12 or J12 has an error in it, then you'll get an error
returned for the sum.


Micayla Bergen wrote:

yes i want to sum the numbers in the cells, not combine them. so i changed
the & to + but got a value error.

"Dave Peterson" wrote:

This formula returns text:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",I12&J12)

Did you mean i12+j12 (to sum those numbers).

If i12=123 and j12=456, then i12&j12 = 123456. But i12+j12=579.


Micayla Bergen wrote:

= SUM('A & E John Super'!$P$4:$P$39)/SUM('A & E John Super'!$L$4:$Q$39)
where =IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,
FALSE))),"",I12&J12) is on the A & E John Super worksheet
there are values on the AEJohn worksheet but they are not adding up on the
other worksheet. do i need another reference or ' or something?
thanks

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

  #12   Report Post  
Dave Peterson
 
Posts: n/a
Default

I'm confused.

I12 is a in row 12 in column I. J12 is in row 12 column J.

I don't see how
=sum(i12,j12)
could return an error

Micayla Bergen wrote:

in row A I12 is $10821.00, J12 is nothing, in row B I12 is nothing and J12 is
5430 but there is no pattern to which is blank on which row.

"Dave Peterson" wrote:

What does I12 evaluate to?
What does J12 evaluate to?



Micayla Bergen wrote:

I12is =IF(G4=0,H4*D4, "")
J12 is =IF(G4=1,H4*D4, "")
G4 is =IF(ISERROR((VLOOKUP(A4,'Model Portfolio'!$C$6:$C$50,1, FALSE))),0,1)
H4 is a vlookup
D4 is a manually input number

"Dave Peterson" wrote:

What's in I12?
What's in J12?



Micayla Bergen wrote:

yes

"Dave Peterson" wrote:

How about the sum(i12,j12) suggestion--do you get an error then?

Micayla Bergen wrote:

only one cell will have a value because it denotes which type of product it
is, but im not sure how to say look in either one so ive said both.

yes i get the error when by itself

"Dave Peterson" wrote:

Do you get the error when you put:
=i12+j12
in a cell by itself (just for testing purposes).

For this expression to work, both I12 and J12 have to be numeric (or empty).

If there's a chance you have text in those cells, maybe:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",sum(I12,J12))

would work better.

===
Be aware that if either I12 or J12 has an error in it, then you'll get an error
returned for the sum.


Micayla Bergen wrote:

yes i want to sum the numbers in the cells, not combine them. so i changed
the & to + but got a value error.

"Dave Peterson" wrote:

This formula returns text:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",I12&J12)

Did you mean i12+j12 (to sum those numbers).

If i12=123 and j12=456, then i12&j12 = 123456. But i12+j12=579.


Micayla Bergen wrote:

= SUM('A & E John Super'!$P$4:$P$39)/SUM('A & E John Super'!$L$4:$Q$39)
where =IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,
FALSE))),"",I12&J12) is on the A & E John Super worksheet
there are values on the AEJohn worksheet but they are not adding up on the
other worksheet. do i need another reference or ' or something?
thanks

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
  #13   Report Post  
Micayla Bergen
 
Posts: n/a
Default

Ok so the value of I12 and J12 is put into columns L M O P or Q based on what
classification it has, but when i try to sum the values in those columns it
comes up as an error.
on the summary sheet i have = SUM('A & E John Super'!$L$4:$L$39)/SUM('A & E
John Super'!$L$4:$Q$39)
and this is returning the error. i dont know if its because of the format of
the values on the sheet or something...


"Dave Peterson" wrote:

I'm confused.

I12 is a in row 12 in column I. J12 is in row 12 column J.

I don't see how
=sum(i12,j12)
could return an error

Micayla Bergen wrote:

in row A I12 is $10821.00, J12 is nothing, in row B I12 is nothing and J12 is
5430 but there is no pattern to which is blank on which row.

"Dave Peterson" wrote:

What does I12 evaluate to?
What does J12 evaluate to?



Micayla Bergen wrote:

I12is =IF(G4=0,H4*D4, "")
J12 is =IF(G4=1,H4*D4, "")
G4 is =IF(ISERROR((VLOOKUP(A4,'Model Portfolio'!$C$6:$C$50,1, FALSE))),0,1)
H4 is a vlookup
D4 is a manually input number

"Dave Peterson" wrote:

What's in I12?
What's in J12?



Micayla Bergen wrote:

yes

"Dave Peterson" wrote:

How about the sum(i12,j12) suggestion--do you get an error then?

Micayla Bergen wrote:

only one cell will have a value because it denotes which type of product it
is, but im not sure how to say look in either one so ive said both.

yes i get the error when by itself

"Dave Peterson" wrote:

Do you get the error when you put:
=i12+j12
in a cell by itself (just for testing purposes).

For this expression to work, both I12 and J12 have to be numeric (or empty).

If there's a chance you have text in those cells, maybe:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",sum(I12,J12))

would work better.

===
Be aware that if either I12 or J12 has an error in it, then you'll get an error
returned for the sum.


Micayla Bergen wrote:

yes i want to sum the numbers in the cells, not combine them. so i changed
the & to + but got a value error.

"Dave Peterson" wrote:

This formula returns text:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",I12&J12)

Did you mean i12+j12 (to sum those numbers).

If i12=123 and j12=456, then i12&j12 = 123456. But i12+j12=579.


Micayla Bergen wrote:

= SUM('A & E John Super'!$P$4:$P$39)/SUM('A & E John Super'!$L$4:$Q$39)
where =IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,
FALSE))),"",I12&J12) is on the A & E John Super worksheet
there are values on the AEJohn worksheet but they are not adding up on the
other worksheet. do i need another reference or ' or something?
thanks

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

  #14   Report Post  
Dave Peterson
 
Posts: n/a
Default

I would think it would be easier to go back to the original range and fix up
errors the

=if(iserror(SUM('A & E John Super'!$L$4:$L$39)
/SUM('A & E John Super'!$L$4:$Q$39)),"Error",
SUM('A & E John Super'!$L$4:$L$39)
/SUM('A & E John Super'!$L$4:$Q$39))

If you use =sum(somerange) and that somerange contains an error, you'll get an
error back.



Micayla Bergen wrote:

Ok so the value of I12 and J12 is put into columns L M O P or Q based on what
classification it has, but when i try to sum the values in those columns it
comes up as an error.
on the summary sheet i have = SUM('A & E John Super'!$L$4:$L$39)/SUM('A & E
John Super'!$L$4:$Q$39)
and this is returning the error. i dont know if its because of the format of
the values on the sheet or something...

"Dave Peterson" wrote:

I'm confused.

I12 is a in row 12 in column I. J12 is in row 12 column J.

I don't see how
=sum(i12,j12)
could return an error

Micayla Bergen wrote:

in row A I12 is $10821.00, J12 is nothing, in row B I12 is nothing and J12 is
5430 but there is no pattern to which is blank on which row.

"Dave Peterson" wrote:

What does I12 evaluate to?
What does J12 evaluate to?



Micayla Bergen wrote:

I12is =IF(G4=0,H4*D4, "")
J12 is =IF(G4=1,H4*D4, "")
G4 is =IF(ISERROR((VLOOKUP(A4,'Model Portfolio'!$C$6:$C$50,1, FALSE))),0,1)
H4 is a vlookup
D4 is a manually input number

"Dave Peterson" wrote:

What's in I12?
What's in J12?



Micayla Bergen wrote:

yes

"Dave Peterson" wrote:

How about the sum(i12,j12) suggestion--do you get an error then?

Micayla Bergen wrote:

only one cell will have a value because it denotes which type of product it
is, but im not sure how to say look in either one so ive said both.

yes i get the error when by itself

"Dave Peterson" wrote:

Do you get the error when you put:
=i12+j12
in a cell by itself (just for testing purposes).

For this expression to work, both I12 and J12 have to be numeric (or empty).

If there's a chance you have text in those cells, maybe:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",sum(I12,J12))

would work better.

===
Be aware that if either I12 or J12 has an error in it, then you'll get an error
returned for the sum.


Micayla Bergen wrote:

yes i want to sum the numbers in the cells, not combine them. so i changed
the & to + but got a value error.

"Dave Peterson" wrote:

This formula returns text:

=IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,FALSE))),"",I12&J12)

Did you mean i12+j12 (to sum those numbers).

If i12=123 and j12=456, then i12&j12 = 123456. But i12+j12=579.


Micayla Bergen wrote:

= SUM('A & E John Super'!$P$4:$P$39)/SUM('A & E John Super'!$L$4:$Q$39)
where =IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,
FALSE))),"",I12&J12) is on the A & E John Super worksheet
there are values on the AEJohn worksheet but they are not adding up on the
other worksheet. do i need another reference or ' or something?
thanks

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simplify formula Luke Excel Worksheet Functions 37 May 6th 05 07:21 AM
Looking for a working production formula so I can add to staff? JJL Excel Discussion (Misc queries) 0 March 11th 05 05:11 PM
Formula entered not working Thrava Excel Discussion (Misc queries) 5 March 6th 05 10:18 PM
Formula not working Carl Hilton Excel Worksheet Functions 13 January 9th 05 07:55 PM
Relative Indirect Formula Referencing? Damian Excel Worksheet Functions 1 January 7th 05 05:16 AM


All times are GMT +1. The time now is 12:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"