messing

i'm trying to do a sumif i tried attaching a photo but not sure it worked and don't want to attach my excel at the moment sumif(I:I,"1",(e119+J119)) The part in red is where I think i'm messing up. What I'm trying to say here is sumif the result in column I is "1" then sum these two cells.

I would like my users to be able to copy and paste freely on a ListObject table, but only values (i.e. not messing with formatting/data validation). Is this possible with a worksheet change event ? many thanks Andrew

Hello, What exactly is the difference between doing something like "<>hello" and "<hello>". I hate using sum product because I always forget how to use it, so I am using a =sumifs like this.......... =sumifs(A1:A100,B1:100,"<>*033000*"). I figured out that is the way it works...

Hello, I am trying to perform a VLOOKUP. It is successfully pulling most of the information, but sometimes it just skips over a value without pulling the number from the data array. I have tried messing with the formatting of the cell and checked for leading and trailing spaces. Any idea why...

Hi - Could someone kindly help me work out the below (a little stuck with it); =INDEX(Sheet1!AG2:AK36,MATCH(A10,Sheet1!A2:A421,0),MATCH(A1,Sheet1!AF2:AF421,0),MATCH(B9,Sheet1!AG1:AK1,0)) Been messing around with it for ages and just can't get it to work. Thanks in advance!

I need a formula that will count the numbers within a range of formulas..ex: in cell A1 838800 cell A2 838809..im using 1+ (A2-A1) which works but if I have nothing in A1 and A2 I don't want it to show a 1..i want 0 as this is messing up other totals

Hi, first post so hopefully I don't sound like too much of a novice! I want to have certain rows with a character reference running from A-Z However I only want it to have a reference if there is data on that row. For example if cell B1 has data then I want A1 to say "A" If the next row holds...