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
|