add

Hello, I'm looking to use this formula =SUMPRODUCT(LEFT(G3:G100,2)+(RIGHT(G3:G100,8))) with cells that have numbers in but some in the middle are blank. If I try and return it at the moment, I get a value error due to blank cells. How do I get it to skip blanks? I don't want to shorten the...

Hi am not able the add some contains if i save as the active workbook . I want to save as the excel file based on tab name with add additional contains in mid if my active tab name is ML51HJ0 MTD Aug(tab name not fixed it will change) my query is save as the file name ML51HJ0_AcntAnalysis...

I am trying to modify my countif statement. I like to enter a start(a1) and end date(b2) to have my formula filter and count only the date range. is this possible? any help would be appreciated. =COUNTIFS(E2:E100,"Apples",G2:G100, "Accepted")

i have 6000 rows in my range, i want to add a comma to the 7 character location from end. i have this formula that i tested in a single cell and it works BUT when I try to apply it to the entire range using a With Range, the syntax is off (get mismatch error) can anyone assist with proper...

Hi team, I have a bit strange problem. Quite often one payment needs to be split to several invoices. Most days there are no issues, however some days this split data total does not add up to original number. If there is a difference I would like to use some formula to try to find combination...

Hello all, I have a coding that adds appointments to the outlook calendar. The situation is that i have a date in a cell. The coding would then make an appointment 90 days from the date entered. The issue is, what do i add to the coding so in case the 90 days falls on a Saturday or Sunday, it...

Please help! I am struggling so bad! I am trying to run 4 potential values. C11 can contain "Mini" or "Regular" Mini = 5.50 Regular = 6.50 BUT If H11 contains "Lays","BBQ","Doritos", then add .50 to total. So if they select one of those options, the total then becomes 6.00 for a Mini &...

Hi Everyone, hope you can help I need a formula or macro to add new sales to existing sales invoices. we have clients that p[lace orders and pay over 16 instalmentsand offten add new items to the first order When we get and order an invioce schedule is created with dates and amounts due...

Hi I have over 500 workbooks, I want to add the workbook name in column AD for every row with text in it for all 500 spreadsheets. I plan to merge them into one master spreadsheet but I need to know which spreadsheet the data came from. Can someone please help me with the first part to add the...

Hello, I have the following code on my userform "frmPOS" to check if any entered client name if exist or not, if so, get the ID and mobile to txtID and txtMobile If not, pop up msg that this is not exist and if I need to add a new client, if so, show the form "frmNewClient" and add new client...

So I have a spreadsheet that I have a drop down for the month of the data, when I change this month then I want the cell in my next table to increase y 1 month. In other words if I select June on B2 then I want K2 to change to July. I have tried a few different formulas but I am failing. Here...

HiI have created a table & in column B I enter a number (i.e 3) is there a way to automatically add 2 rows below the line, so if the number was 5, it would add 4 rows below?RegardsStephen

Hi Everyone, I Have two ranges D20:D250 & F20:F250 I need a total these with this rule Not all cells have a value, Column D needs to be ignored if column F has an amount example <tbody> Column D Column F 5 6 34 43 12 17 66 12 12 15 6 35 4 44 4...

Hello all I hope you can help on this formula, I want to try to compare day on day sales comparison over 2018 / 2019 At the moment I have a sumifs statement that just adds up for each month and a running total for the year, it's fine for this year as it will add up to today but last year...

Hi good morning, please can you help I want a formula for; IF Cell O2:O17 = 7 or greater then cell M2:M17 to add note in cell 'Fully Utilised' please can you help.

I have a combo box on my user form and I can not find it anywhere. I have used code to move it and make it colors and visible to locate it to no avail. Is there some code to just delete it so I can add a new one? Tired of looking for it. Thanks

https://1drv.ms/x/s!AvjBsEPEq12ngT4paIVYB5-Ol3Y2?e=XitD7z Hi guys, I have monthly revenue data that I want to add (YTD figure) Need a formula whose output updates based on say if I choose YTD May. Then it should add months 1 to 5 for the year. How would you approach this solution?

Hi, I want to be able to put my own custom icons in Excel. The code below works nicely, but instead of FaceID, I want to replace it with my own icon or image. Can someone help me with this problem. Public The_Menu As CommandBar Function CreateSubMenu() As CommandBar Const pop_up_menu_name =...

hi, reposting and rewording my question to reflect the time zone I am in. I spent about 23 hours trying to figure this out with a sleepless night but to no avail. I have a UserForm and one combobox on it, I need to add only some of the worksheets to the drop down list and be able to switch...

I need to add spaces in the beginning and end of a text. e.g Text is John. I need 4 spaces before J and 7 spaces after n. How to accomplish this.