sumifs multiple criteria

I've been using this awesome forum for many years, getting all of my Excel questions answered by the awesome forum members and Excel gurus, but now I'm having a task to which I cannot seem to find an already existing topic/solution for, thus this is my first post. I'm having (almost) the same...

Akk Help Ok my sumif formula works fine (List!B3:B14,AC4,List!D3:D14) returns the proper value, now I need to add two additional criteria to that so if B4 = "V" and if AD2971 >= 91 then I need it to return the value from the sumif and of course return a blank if the criteria are not met...

Hello all, in need of some "M" wizardry to recreate the functionality of this SUMIFS formula. My current skill level with "M" consists of hastily key-word searching the M formula language .pdf so a SUMIF is way over my head. I'm using this SUMIF to compute a running daily balance based on each...

Good morning I have a SUMIFS formula from 2010 (below) which I need to use in Excel 2003, any ideas? =SUMIFS('Source Data'!N:N,'Source Data'!G:G,C4,'Source Data'!C:C,B4) Thanks very much in advance

Hello, I am using a Google Spreadsheet to calculate total number of gift certificates sold by year AND (ideally) by gift certificate type (2 types: full or partial). An example spreadsheet with fake data is here...

I have created the following array formula which works fine to sum based on the multiple GL accounts. Now i want to add another criteria in to the formula to only sum based on months. My data is in a list from and it is for 12 months. The idea is that formula will look at the header for month...

Hi All, I'm wanting to use the sumifs function with one of the criteria having more than one possible correct matches. I know the normal SUMIFS function would work as follows yielding a total from cells G10 through G100 based on whether a common row in the range contained in columns A, B, and...

Hello everyone :) I need some help with a database I'm trying to build in excel. Currently I have a list of all processes carried out in my office for my team. There are 4 main processes and each process has a subset of activities relating to it, for example process "BAU" has several activities...

I've searched a lot of forums and videos to try to find an answer for this, but can't seem to make any of those solutions work. I have columns B,D,E, and F with relevant data. Column B is an admin code that I'll use for the range (SUM) or criteria range (SUMIFS) and I'll use column D for the...