Averaging IF with multiple values

**axc0054** · 02-01-2008, 08:22 PM

I originally was using this function to declare a value until I came across records that had been updated with new values. How can I sum or average this to remove #value?

What am I doing wrong?

Original Function:
=IF(ISERROR(VLOOKUP(Purchased!A6,'Cut Tube Issues'!A:K,11,TRUE)),"",VLOOKUP(Purchased!A6,'LWC Issues'!A:M,9,TRUE))*F19

Output: #value

Second Try:
=AVERAGE(IF(ISERROR(VLOOKUP(Purchased!A6,'Cut Tube Issues'!A:K,11,TRUE)),"",VLOOKUP(Purchased!A6,'LWC Issues'!A:M,9,TRUE))*F19)

Output: #value

Third Try:
=AVERAGE(IF(Purchased!A6,'Cut Tube Issues'!A:K<>0,Purchased!A6,'Cut Tube Issues'!A:K(ISERROR(VLOOKUP(Purchased!A6,'Cut Tube Issues'!A:K,11,TRUE)),"",VLOOKUP(Purchased!A6,'Cut Tube Issues'!A:K<>0,Purchased!A6,'LWC Issues'!A:M(Purchased!A6,'LWC Issues'!A:M,9,TRUE))))

Output: Entered to many arguments or Your formula is missing a parenthesis...

**DOES** · 02-02-2008, 05:47 AM

Post the file to fix.

**axc0054** · 02-04-2008, 01:21 PM

The smallest file I have sits at a whopping 17mb... can I host that somewhere that big?

Try this link.

http://www.sharebigfile.com/en/file/...Q-NEW-zip.html Edited for new link. PW= Copper

**axc0054** · 02-05-2008, 02:56 PM

I added a new link to my previous message. I think the last site linked was asking for registration info...I found a slighty better place that did not require that.

I hope this helps for those who can identify my problem. Thank you for those who have looked.