Posted to microsoft.public.excel.worksheet.functions
|
|
sum column with na from v lookup
Thank you!
"starguy" wrote:
if all values are positive then simply use SUMIF function
=SUMIF(A5:A100,"0")
i supposed that your data which you want to sum is in the range of
A5:A100
you can adjust this range according to your data.
DERICKSON Wrote:
The column I am trying to sum contains the formula
=VLOOKUP(B620,'S:\Accounting\Donna\SAP Go Live\[Go Live Inventory
Download
080806 Rec to 1550 081706 dje.xls]1550 not loaded
final'!$B$3:$F$125,5,FALSE)
Is there a Sum Formula I can write that excludes the #N/A values which
are
showing in the column as a result of the vlookup? I would like to find
a sum
function so that I do not have to use the auto filter on my large
spreadsheet
and the sort it would require.
Donna
--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=573389
|