then

List 1 has item numbers, and I want to return total sales dollars. List 2 has the item numbers across multiple locations, and I want to return the total sales dollars into column B on List 1. What formula do I need to put in B2 to return the total sum? (B2 Value should return $315, B3=$230...

Hi All, Do you know a formula that can return the word "include" if the cell in column A does not start with a number ? Here is an example and result A1 345C5T64 B1 A2 C8744343 B2 include A3 B3 include A4 Non CI B4 include A5...

Hello! Today is my first day exploring VBA coding, and I'm having trouble with the below 'if/then' VBA code (also attached a screenshot). In short, what I need is for data in Column E to automatically populate according to what is in Column D. For example, if any rows in Column D read...

I'm trying to make something like this (I'm a noob on excel don't know if this is possible): If beetween J33:J54 the number 4 repeats then show the number 3 on J55 but if it doesn't repeat show the lowest number on that column, Also if there's a number lower then 4 in j33:j54 even if 4 repeats...

I need a macro to, IF i5=-99 THEN delete A5:C5, then it needs to move to cell i6 and perform the same check IF i6=-99 THEN delete A6:C6. Needs to keep repeating this line by line check until reaching i1057. I don't expect necessarily to see the cursor moving through the sheet, just to end up...

Hello, I was wondering if I could tell excel to insert a value (1 or 2) along all of column B, based off the values that are in column A. For example If A = 1 or 3 or 5 or 6 or etc... Then values in column be should be 1. and If A = 2 or 4 or 7 etc... Then values in column B should be 2...

I have a worksheet containing cells G3:G100 that needs text and fill formatting via a “Conditional Formatting” rule that looks at the corresponding cell in the “H” column to see if the text contains any one of the letters B, D, F, H, J, L, N, P, or R. The actual contents in H3:H100 are any one...