Seasons shoes,

I have a friend who has bit of a prob....

He has a column of values that are calculated from VLOOKUPs, and he wants to do a SUM() on this column, but just a basic SUM returns #N/A, im guessing because the columns have formulas and not values in them.

Any idea how to calculate the sum of a column of formulas?

Thanks in Advance!

Many shoes,

Jamez/SiliconFuRy

__________________
Many shoes,

Jamez/SiliconFuRy

I think that it is more likely that there is at least one #N/A in the column where the VLOOKUP() has not found a value.

If non-matches are expected then the following method puts zero instead :-
=IF(ISERROR(VLOOKUP(A1,Sheet1!$A$1:$B$15,2,FALSE)) ,0,VLOOKUP(A1,Sheet1!$A$1:$B$15,2,FALSE))




-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.

So you're saying that if the column with vlookups has values in it (no #N/As) then the SUM should work?

Thanks for the code snippet ;)

Many shoes,

Jamez/SiliconFuRy

And if you wish to have the sum working without having to change vlookup formula, Instead of SUM just use Sumif (as follows)
(Range_of_cells_containing_values_amd_NA,Criteria)

Where Criteria = "<>#N/A"

Regards
Amjad