Hi all
I run a basic excel for keeping track of my product imports. The meat of it is "Product Name" "Unit Cost" after all the S&H, Tax math has been done.
My problem is that the unit cost varies with each order.
I use =countif to determine how many times the product name pops up in my sheet but wanted to see if i could turn that to into the average unit cost of that product.
Hope that makes sense.
Any help is appreciated.
Rgds
Marc
I run a basic excel for keeping track of my product imports. The meat of it is "Product Name" "Unit Cost" after all the S&H, Tax math has been done.
My problem is that the unit cost varies with each order.
I use =countif to determine how many times the product name pops up in my sheet but wanted to see if i could turn that to into the average unit cost of that product.
Hope that makes sense.
Any help is appreciated.
Rgds
Marc