sumif /sumifs vertically

Hi, I have below sheet that has multiple rows for each employee ID and what I need is to get a proper formula to sum amount 1 and sum amount 2 for each employee, can you help pls? ABCDE1Employee IDAmount 1Amount 2Sum Amount1Sum...

I have a list with unique references. I want to look up these references on another data sheet, where they might appear multiple times and with different result data. Using vlookup only returns the first instance of that reference being found and I need to know them all, or at least total of...

Hello, this is my first post here but this seems to be a friendly place. I currently have data from our reporting software sending information that is helpful to read, but not to analyze. Right now I'm trying on another tab to calculate the field if it matches two criteria. Those are if the...

Not sure if I can do what I want but I think I want a sumif v lookup formula. This is my scenario I have 3 columns in my range. First one being my reference number, my second column has a weekly value in it and my 3rd column is a running balance. So what I want is a running total of the weekly...

I have to make a report to get the sales of the wholesaler ,but only sum the sales of the dealers which is more than 30. I want to know which formulae to use and how...

Hello I need help summing data in a column if the range of columns falls on a certain day. See below for an example of my Gantt spreadsheet. It is divided into 8 hour days. The jobs are on the left side "Y" axis and their progress is depicted in each row. To the right of the job are the...

Good Morning, I was hoping someone might be able to help me out with the following question: I have built a spreadsheet that generates data on a monthly basis for 100 distinct "blocks" (January through December, vertically oriented, 100 times; the example below features only 2 months for 1 of...

Hi I've got a formula that's not working, as expected. Please find below a very simple sample of the data and formulae I've used: If you copy and paste the data below, it should go from cell A1:H7. I'd like to use a sumif to do two things 1) get the weight of the "Promo sales" for each...

Hi, I have a question regarding Sumif As we all know Sumif doing sum of horizontal data there is any way to sum the vertical value while using of Sumif/sumifs function .? Please I need ur help