Latest activity
-
p45cal replied to the thread Help with a Countif formula.I see you've already got some summing formula in colums around BA on each sheet. Make sure that these fomulae are on the same column in... -
Rrwwall replied to the thread Help with a Countif formula.Unfortunately not. The shorter months will have run into the violation count and it will add those to the as well. That is what is...
-
AliGW replied to the thread Beginner Pointers for VBA.It has been brought to our attention that the same question has been asked by you elsewhere. Please provde a link to each of the other... -
EHi there! I've been using Excel regularly for about a year now, so I'm still getting my bearings. However, I'm excited to deepen my...
-
p45cal replied to the thread Help with a Countif formula.Don't all the sheets have the same arrangement but the end of the month numbers are missing in row 4 when appropriate? In those shorter...
-
Rrwwall replied to the thread Help with a Countif formula.Good afternoon, I apologize I have one more question. How do I adjust for months that have less than 31 days. Currently the formula...
-
p45cal replied to the thread Range error.Yes
-
Rrwwall replied to the thread Help with a Countif formula.Thank you. The hidden sheets are at the end the workbook. the ones with the data validation information etc.
-
TTanMan replied to the thread Range error.My man! that got the debug issue to appear. So im really just trying to do an If/then statement but I cant seem to get it to actually...
-
-
p45cal replied to the thread Range error.Where are you running this code from?! It looks like you're running it in a worksheet code-module (there's no Debug button to click)...
-
-
TTanMan replied to the thread Range error.It ,matches the excel file name but does it have to match the sheet at the bottom? This is the error so I am not sure which line.
-
-
p45cal replied to the thread Range error.On which line? A guess, you don't have a sheet called 3w5ghebh in the same workbook as the code. If you think you do, copy the sheet...
-
THello, I have the below code and I am getting Subscript out of range error? Not sure how to fix it. Thank you Sub...
-
p45cal replied to the thread Cost Allocation formula.No different.
-
p45cal replied to the thread Help with a Countif formula.=SUM(FILTER(VSTACK(January:December!$O$5:$AS$34),ISNUMBER(SEARCH("7 Day Cycle violation",VSTACK(January:December!$F$5:$F$34))),0))Make...
