= 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

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

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

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

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

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