Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Exceln00b

    Excel Sumproduct Query

    my response is below: General comments: 1: You ought to be using REAL DATES. Rather, you are using LABLES 'Nov-07, which in many cases are virtually useless except for lables. They will not sort correctly, let alone be able to be used in calculations. Ans: Well the raw data i download...
  2. Exceln00b

    Excel Sumproduct Query

    oops sorry, I do have a solution for the query, but its long winding. the formula that you see in the cells, E24-K34 of the Display.xls file does the calculation and is the fix. What am trying to do is to find an easier, less cumbersome formula to get the same result. to be clearer, am...
  3. Exceln00b

    Excel Sumproduct Query

    here ya go. k, now display is where I want the data displayed. The count of the 10's, 9's should be displayed against the list with colour coding (10-0) This is based on a monthly cycle (the month is displayed in E8 - K8) And the count displayed, depends on the drop down menu in B6. I do...
  4. Exceln00b

    Excel Sumproduct Query

    oopsss... the mail failed to deliver. Am attaching the link here http://www.mediafire.com/file/myn40nz1zln/Display.xls http://www.mediafire.com/file/qzm3mwmjzmz/Raw D.xls Thanks again. Please let know if you have issue viewing the file.
  5. Exceln00b

    Excel Sumproduct Query

    Mailing you the file,Skip you are kind and I really appreciate your help. IOU
  6. Exceln00b

    Excel Sumproduct Query

    Thanks Skip, your hint has sparked another idea, anyway, am attaching the files, Raw D.xls is the raw data file (I have deleted many of the fields and have just kept a few so that you would get an Idea) The other File is Display.xls where I plan to display the results. have attached a copy as...
  7. Exceln00b

    Excel Sumproduct Query

    dang! that worked like a charm. Thanks a TON!!!! well, probably i should start a new thread, but since the question is related to the previous formula, I am hoping that you can provide a better, easier and less complex formula. So here goes : I have two files, one which contains the Raw...
  8. Exceln00b

    Excel Sumproduct Query

    can someone tell me if this is a wrong usage? =IF(B6="EM";SUMPRODUCT(--(E8='[Raw Data.xls]Sheet1'!$I:$I)+('[Raw Data.xls]Sheet1'!$CX:$CX="10"));SUMPRODUCT(--(B6='[Raw Data.xls]Sheet1'!$L:$L)*--(E8='[Raw Data.xls]Sheet1'!$I:$I)*--('[Raw Data.xls]Sheet1'!$CX:$CX="10"))) It returns a #num! value...

Part and Inventory Search

Back
Top