Thursday, November 1, 2012

yogi_Pull Product Info And UnitPrice For Items From Sheet1 And Compute TotalOrderPrice


                                           Google Spreadsheet   Post  #843
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 01, 2012
user MiaCatherine said: (http://productforums.google.com/forum/?zx=gdxpen6jynp#!searchin/docs/MiaCatherine/docs/21Av5RhhBBw/_3ytVTxz81oJhttp://productforums.google.com/forum/?zx=gdxpen6jynp#!searchin/docs/MiaCatherine/docs/21Av5RhhBBw/_3ytVTxz81oJ)
CountIF reference in another workbook
I am attempting to use a countif function to create an inventory from another workbook.

This is the sheet (one of the sheets) I need the inventory to populate on:


This is the sheet is will "countif" from:


(there's nothing really there yet, I need this to work before I can add things)

Inventory:
I need the first sheet to check through the second sheet in a different workbook to see if that product occurs and how many times it was listed.
-------------------------------------------------------------------------------------------------