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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by pbundrant

  1. pbundrant

    SUM, INDEX, MATCH for multiple columns

    Thank you Combo, I got a solution for my issue. I use 2016 though. I will add PowerQuery here, I have it at home. :D Patty
  2. pbundrant

    SUM, INDEX, MATCH for multiple columns

    No it is not. :)
  3. pbundrant

    SUM, INDEX, MATCH for multiple columns

    LOL!!! Like is said...staring right at me. Thank you!! It was my ranges, in all the back and forth checking and rechecking, I confused my AssetSpec with my DataCost and changed the reference cells in both. It works now.
  4. pbundrant

    SUM, INDEX, MATCH for multiple columns

    Thank you Skip. I can't get it to work, after checking all the data, the ranges, and putting the formula in the data sheet, still no good. UGH! Makes no sense to me, I'm sure the problem is staring me in the face, it usually does.
  5. pbundrant

    SUM, INDEX, MATCH for multiple columns

    Yes, I verified all costs are Numbers, currency actually and all AssetSpec cells are text. No change. Thank you!
  6. pbundrant

    SUM, INDEX, MATCH for multiple columns

    Hi Skip, Asset Spec is in column G "G10:G28025" on sheet A_LCCP. I did change my name and used your name "DataCost" for the $ columns R-AY, no Column G is not included in the DataCost="R10:AY28025" range. =SUMPRODUCT((AssetSpec=$A7)*(DataCost))
  7. pbundrant

    SUM, INDEX, MATCH for multiple columns

  8. pbundrant

    SUM, INDEX, MATCH for multiple columns

    It's not even the true values, why would a #Value error occur when looking at text data? This is the part that gets all the errors, randomly. (A_LCCP!$G$10:$G$28025=$A7) I did name the range, I just changed it to check for errors in the saving of the range. Which equals your (AssetSpec=$M5)
  9. pbundrant

    SUM, INDEX, MATCH for multiple columns

    I'm getting a #VALUE error for every True instance :( Thank you for your help.
  10. pbundrant

    SUM, INDEX, MATCH for multiple columns

    Hello combo and SkipVought, I will include a stripped down version of my data for your more detailed recommendations. I believe my match needs another or several more match statements. Thank...
  11. pbundrant

    SUM, INDEX, MATCH for multiple columns

    Hello, Can anyone please let me know what I am missing in my formula? This is the formula that I have: =SUM(INDEX(A_LCCP!$A$10:$A$28046,MATCH($A7,AssetSpec,0)):INDEX(A_LCCP!$AY$10:$AY$28046,MATCH($A7,AssetSpec,0))) It works BUT! I need the sum of multiple columns. The value of A7 is in many...
  12. pbundrant

    Min/Max Average Formula Not showing single value

    I was given this formula in another forum and works beautifully! =IF(COUNT($H12:$AA12)>1,(SUM($H12:$AA12)-MIN($H12:$AA12))/(COUNT($H12:$AA12)-1),IF(COUNT($H12:$AA12)=1,SUM($H12:$AA12),"")) [elephant2]
  13. pbundrant

    Min/Max Average Formula Not showing single value

    So is there a way to direct the ELSE value to the only value in the range?
  14. pbundrant

    Min/Max Average Formula Not showing single value

    Here is my formula: =IF(COUNT($H5:$AA5)>1,(SUM($H5:$AA5)-MIN($H5:$AA5))/(COUNT($H5:$AA5)-1),"") The problem is that it removes a value when it is the only value in the row. Can anyone suggest perhaps a different formula? My goal is to find the "pessimistic avg" and the "optimistic avg"...
  15. pbundrant

    Code to Print or Preview Report based on Subform

    There was no filter turned on. All filters turn on when GotFocus. Adding ActiveFilter in If statement fixed the problem. Private Sub cmdPreviewFilteredReport_Click() Dim subFormFilter As String Dim ActiveFilter As Boolean subFormFilter = Me.frmLianzi_MDR_Form_Updates.Form.Filter...
See more

Part and Inventory Search

Back
Top