“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I am trying to SUMIF a code in A2 on one sheet and for it to give me the total from a column on sheet2. I have tried the below but it gives me 0 when i know it should be 2?
=SUMIF(A3,">0",'Opening Stock'!L2:L3)

Solved by K. S. in 13 mins

I am trying to utilize a complicated sumif or sumifs formula that can pull a total amount from a date and a drop down box from another tab.

Solved by E. B. in 25 mins

I need help with a SUMif / Count if formula that works with text values. It's for a game.

Solved by Z. B. in 23 mins

I'm using an array function to calculate the number of overlapping days in a vertical set of date ranges, but i want to separate the counting of overlapping days based on a value in column A of each row (i.e., still compare the date in a row to all of the other dates in the spreadsheet to see if there is overlap, but total the overlap in two sets based on the two possible values in column A). Alternatively, i could use an array function that gives overlap values by row and then use a sumif function, but only if i can figure out how to not double count overlapped days.

Solved by K. Q. in 30 mins

Need to sumif across multiple sheets starting from a sheet of "Start" to a sheet of "End"

Solved by X. F. in 22 mins

Hi,
I'm trying to sumif an index match and although it's working for the first year, the formula is throwing up incorrect values for the rest of the term- I can't figure it out! (Got a 10 year cashflow in quarters, trying to sum the rent in each year)

Solved by I. H. in 14 mins

I have a SUMIF statement that subtracts values from another value if they are less than 0, and if the category that they are categorized in, lines up. I want to add a simple condition, where if the date a transaction is placed, falls into the month that is specified, in addition to the other conditions, then it performs the operation. It seems simple, but I can't seem to figure it out...
In the profit allocation sheet, cells C9-C11 have the SUMIF statements. They reference the Ledger page. I want to add the condition, "If the date in the ledger page (column A) falls into the month in cell B2 in Profit Allocation (in this case February)".

Solved by S. Q. in 28 mins

Hi, I am trying to do a sumif across multiple sheets in excel. Basically I need to match the row label to a date on each across multiple sheets

Solved by K. H. in 20 mins

I would like to take all of my transactions from last year and filter out certain retailers i.e. The Home Depot
I've tried the sumif function but i get a 0 value, please help

Solved by S. Q. in 28 mins

Hi,
I'm trying to find out the number of specific operations (Criteria in column) we'll have within a specific date range (criteria in row). To my knowledge, some form of sum or sumif is required along index and match. Any help would be appreciated.
In the file attached, I am trying to find out how many Operational days we'll have in FY2018 (cell Q12), within the date range (N12:O12), for a specific operation type (P12).

Solved by A. A. in 21 mins