shorter

Is there a shorter way of doing this? please. =IF(AND(A1>0,A2>0),1,0)+IF(AND(B1>0,B2>0),1,0)+IF(AND(C1>0,C2>0),1,0) Basically, if A1 and A2 are greater than 0 at the same time, it should be counted as "1", if not 0, and then all results in the range are summed. My data are like this...

Hi, I have these lines that I need to make shorter with a for loop or anything cooler. I have been on the offset thing for a while now, can’t seem to figure it out. I want someone pull me out. Thanks Sub getCount() Dim i&, j& i = Me.cbByName.ListIndex j = i + 3...

Hi what is a shorter formula which I can use to replace =L101/M101+L102/M102+L103/M103+L104/M104+L105/M105+L106/M106 etc.. Thanks!

I have this formula which works if 'AM Targets'!F6=Budgets!$H$3 : =IF('AM Targets'!C6=Budgets!$L$5,Budgets!$M$6,IF(AND('AM Targets'!C6=Budgets!$G$4,'AM Targets'!F6=Budgets!$H$3),Budgets!$H$4,IF(AND('AM Targets'!C6=Budgets!$G$5,'AM Targets'!F6=Budgets!$H$3),Budgets!$H$5,IF(AND('AM...

Hello, I want make a calculation and if negative to make it zero, while if possitive to leave it as is. I write it as: []=IF(($D$123-D30*$D$10/$D$21)>0,$D$123-D30*$D$10/$D$21,0)[] Is there a way to make it shorter without having to repeat it twice in the formula because it gets very long...

Hey All, This formula is really simple but way too long. There must be a way to make it shorter but I'm not smart enough to do it. Any help would be great...

Hi Mr. Excel, Is there a way NOT to REPEAT the logical_test false statement again, as I wanted the formula to be just shorter. Example: from: =IF(VLOOKUP(D2,Criteria!$C$2:$D$11,2,0)="123",1, VLOOKUP(D2,Criteria!$C$2:$D$11,2,0)) to: =IF(VLOOKUP(D2,Criteria!$C$2:$D$11,2,0)="123",1, some...

Let say I have a function like: SUMPRODUCT((A1:A5)*(B1:B5)*(C1:C5)*(D1:D5)*(E1:E5)) Is there a shorter way to express the range from column A to E?

=((Attendance!$D$3*Attendance!D5))+ ((Attendance!$E$3*Attendance!E5))+((Attendance!$F$3*Attendance!F5))+((Attendance!$G$3*Attendance!G5))+ ((Attendance!$H$3*Attendance!H5))+((Attendance!$I$3*Attendance!I5))+((Attendance!$J$3*Attendance!J5))+...

I am getting this error when I point my macro to a file in a specific directory. Problem is THE FILE IS THERE!!! There are some actions that I have taken: 1. I made copies of the same file with varying length in names. 2. The file with the shorter names are found whilst sometimes the files...

HI ALL Is there a way to simplify this formulae =SUMIFS(R_conveyor_table!$D:$D,R_conveyor_table!$B:$B,'COUNTRY P&L'!D$6)+SUMIFS(R_vacuum_table!$C:$C,R_vacuum_table!$B:$B,'COUNTRY P&L'!D$6)+SUMIFS(R_Jetwash_table!$C:$C,R_Jetwash_table!$B:$B,'COUNTRY...

So here is one that no doubt those VBA gurus amoung you can solve quickly. My code does a simple copy and paste funtion for a formula then overwrites it with a copy paste values. Below is the sample: Sub Update_Actuals() ' ' Update_Actuals Macro ' Updates Actuals on Resources Data worksheet '...

Hi all, I have a macro that I use to clear out selected pieces of information from the current sheet. (about 70 lines) Now, I have several other sheets that need the same cells cleared out. My dilemma is that I don't want to just put inSheets("Page2").Select then put in my 70 or so lines of...

Hi there, in cell E6 I have this formula -...