Recent content by pbundrant

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

No it is not. :)

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.

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.

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

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))

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)

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

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...

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...

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]

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

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"...

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...