adding

Hello guys- I am trying to add another criteria to the below: =IF(ROWS($A$3:A3)>$A$2,"",INDEX(Data!$A$2:$A$110,SMALL(IF(Data!M$2:M$110=Data!$Q$6,IF(Data!C$2:C$110=Data!$Q$8,ROW(Data!$A$2:$A$110)-ROW(Data!$A$2)+1)),ROWS($A$3:A3)))) Would like to add this portion: IF(Data!M$2:M$110=Data!$Q$11...

I could really use some help with this. Is there a way to change KM to MPH on this 2010 Excel spreadsheet adding 2 additional columns and some formula...Really stuck https://drive.google.com/open?id=1cGZLjwaY_N3abteQCJ7nHMUFzFdbyeiy HELP

I need to find a way in excel to show me the lowest amount shipments it would take to send out all of these orders, without splitting individual orders, by adding together rows that could fit under the volume threshold of 3400. Any help would be appreciated. https://imgur.com/a/X8AXTZO image is...

hi all... how to adding mark "-" between number from 2 columns (joined) this layout : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td {...

I am trying to add negative time, hours and minutes (-1:32) to positive time (0:34). These are totals for hours worked above 40 hours. I have changed to the 1904 date system but my formulas aren't working. I'm not very familiar with Excel. I'm trying the formula =SUM(A1+A2) with A1 and A2 being...

Hi I am wanting to sum a group of columns on one sheet if the vertical value is 1. not blank and 2. equals a certain value (like a vlookup) on the criteria sheet and 3 looks at a row on criteria sheet if this cell is "TRUE" it adds this column with the rest. This is to achieve adding all the...

H <30 2 >30 A B 12/31/2018 29 12/31/2018 5 My current Formula (adding the days between 0-29)...

I have a cell AH3 that shows $3.31/Qty Can someone show me how to add let's say a 1 to make it $4.41/Qty to keep the text together or does the text need to be split apart temporarily? Is there another way to do this?

I have the below existing formula that I need to now add a second section to tell it to match to values in a different workbook and am not sure how to structure the formula. Existing formula =SUMIFS($U6:$BU6,$U$2:$B$2,">="&$D6,$U$2:$BU2,"<="&$E6) New formula =SUMIFS(MATCH $C2, NEW WORKSHEET...

Hello All, I have one userform and I am adding textbox and commandbuttons dynamically to it. Now I want to embed not link a picture on one command button so that picture appears on command button even if picture file is not in its location. I tried creating one userform and adding picture to...

Hi everyone, I'm looking to insert a decimal in to be the third character from the right in a sheet with about 5000 different rows all of different lengths. So one row might be 12345 that needs to be 123.45 and the next might be -2345678 that needs to be -23456.78. Thanks in advance.

Is it possible to prevent users from adding the autofilter to Excel?

Hi, sorry if this is a very simple question but I cannot figure it out. I would like to a month average line to my pivot chart, but if I use the average function in excel, it will give me the average by each individual employee. how do I show a total month average? I need it as a pivot...

Is there a way I can tweak this formula so it looks at both the teacher and the subject? I've tried adding AND, adding IF (sub=$a4... at the beginning of the formula but doesn't quite work. {=IFERROR(INDEX(Cls,SMALL(IF(Teach=Sheet4!$FV4,ROW(Teach)-ROW(INDEX(Teach,1,1))+1),1)),"")} All help...

Hi I do not understand why excel multiple a number by 100 before adding % sign. Thank you so much. https://www.extendoffice.com/documents/excel/850-excel-add-percentage-sign.html

I was going to develop a UserForm but decided that just adding a ListBox to the Worksheet would be simpler. I have a decent reference book to help me but I'm finding it is a bit outdated. I've placed my code below. The first line does not allow me to go into Break Mode. So I can only debug by...

this formula works perfect until i add more to it =MAX(FREQUENCY(IF(ISNUMBER(MATCH('Match Database'!$H$2:$H$5000,{"Won","Drew"},0)),ROW('Match Database'!$H$2:$H$5000)),IF('Match Database'!$H$2:$H$5000="Lost",ROW('Match Database'!$H$2:$H$5000)))) (which is an array formula)...

My UserForm updates my data worksheet. I’ve added this line of code to include the date of the update. But the “date entered” column changes all the records to the current day instead of date entered. I thought about adding code to copy the column and paste values but…is there a better way...

I'm writing a macro to add a custom comment. I have everything up to adding text to the comment working. How do I stop the macro from advancing while I'm adding text? Then once I'm done adding text, how do I detect a mouse click so I can turn the macro back on so I can finish and close the...

I have a file with customer IDs and payments per month. How can I determine the best (adding the total amount) customer with the help of one formula? Thank you!