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    Nov 01, 2012
user MiaCatherine said: (!searchin/docs/MiaCatherine/docs/21Av5RhhBBw/_3ytVTxz81oJ!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)

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.