Excel Average If for two different sheets

NDMDRB

Board Regular
Joined
Jun 20, 2016
Messages
128
Hello,

I have a workbook with two sheets, "Items" & "Purchases"

I have two userforms also, "frmNewItem" & "frmPurchases"

In "frmNewItem" I have several textboxes to add the item details to sheet "Items" (one of these boxes is "OpenCost" that added in column "K")

In "frmPurchases" I have several textboxes also to add the purchase invoices to sheet "Purchases" (In column "E" is the cost of these purchases)

In sheet "Items" Column "D" (ex: "D5") I have this formula that get the average cost from sheet "Purchases" of each item...
=IFERROR(AVERAGEIF(Purchase_Barcode,A5,Purchase_Cost),"0")

What I'm looking for is to get the average cost from sheet "Purchases" (As the formula above) and the open "OpenCost" from sheet "Items" column "K5"

Any thoughts!!
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Forum statistics

Threads
1,089,181
Messages
5,406,657
Members
403,100
Latest member
Jmayo

This Week's Hot Topics

Top