Formula Help #VALUE!

[Rescueme]

I am using a spreadsheet that has a lookup formulas in cell H26 that may or
may not be populated at all times. If the cell is populated the end result
is in Column I the following formula will calculate my total. =SUM(B26*H26)
If no value is in cell H26 which will often happen I get #VALUE!. I want my
formula =SUM(B26*H26) to print nothing in the column in the event that there
are no values in cell H26, and print the answer if there are values in H26.

Thanks,
Karen

 

[Frank Kabel]

Hi
instead of SUM(B26*H26) use
=IF(COUNT(B26,H26)=2,B26*H26,"")

Note: The SUM function is not required

 

[Rescueme]

Your count formula is exactly what I am looking for, but for some reason it
works when the first item in the dropdown list is chosen to populate the
cells but not when I choose others from the list. This is the formula in
the H26 that looks up the price from the list, can you see an error in this
formula?

=IF(VLOOKUP($L26,
Plants!$A$1:$Y$100,9,0)="","",VLOOKUP($L26,Plants!$A$1:$Y$100,9,0))

I have the same formula copied down 15 rows.

 

[Frank Kabel]

Hi
maybe your values are stored as 'Text'?
What does the formula
=ISNUMBER(cell_reference)
return for both of your cells

 

[Aladin Akyurek]

Why not just...

=VLOOKUP($L26,Plants!$A$1:$Y$100,9,0)

in H26?

If this formula really returns blanks (i.e., ""), try to use...

=B26*N(H26)

instead of:

=SUM(B26*H26)

[...]