luck

Hello, I am trying to create a summary total for the department # BC for only the batch type R and P. I have tried multiple sumif functions found in this forum with no luck. BATCH TYPE DEPT# BATCH TOTAL P BC $1,949.14 R BC...

Hi all, Simple question, but I am confused... tried using versions of indirect and concetenate with no luck. How do I set the below formula range to be based off the value of a cell? =INDEX(valueofcell:$M$2,MATCH(TRUE,valueofcell:M3>0,0)) The cell I am getting the value for e.g. has the...

I have tried a few combinations but cannot get the end state I am trying to combine these two equations. I've tried using IF(AND(OR without luck. Again thanks for the help! =IF(AND(D2="10k",E2<=120),"Go,"No Go") =IF(AND(D2="20k",E2<=240),"Go,"No Go")

Hi, I am trying to do an array of column widths where specific columns are selected and for each column there is a different width but with no luck, is it actually possible to do this in an array?. Example Column B - width 10 Column D - width 19 Column G - width 16

Hi, My data are A B C D E 1 Type Person Product Total Status 2 AB Peter A 700 1 3 AN Sam B 800 2 4 AB John J 700 3 5 SG Luck A 400 1 6 AN Jam B...

I have a changing range always composed of 1 column. I have the start and end points determined in a loop as L and J. How do I refer to that Range if the column is always "I"? I tried SummarySheet.Range(Cells(9, L), Cells(22, J)) but no luck. I would like to feed this Range into the COUNTIF...

Hi hope someone can help I am trying to open AutoCad LT from excel but not having much luck. anyone kind enough to give me a hand? thanks

Hi there, I am running a fantasy football league in which the factor of how many goals you concede each week is uncontrollable and thus is down to luck. I want to create a forumla which calculates the luck element in order to then rank the luckiest teams. See the attached sample: The main...