sumifs formula

Hi all, below is just some of the code I'm working with. There is a lot in between but essentially I need to utilize the Sourcewb in a SumIfs formula but can't seem to make it work. The Sourcewb will already be open and will be closed when this formula is complete. Any help is appreciated...

I am trying to get the sum quantity of the items both unique and duplicates but with only one output. I've attached my spreadsheet for review, but in case here is what I have. A B C ID Key Item Quantity Mickey wand 6 Minnie...

Hi I'm trying to write a SUMIFS formula that returns the Quantity total of the ItemSKU numbers in the 10000 range in the data below. The data starts in cell A4 ie CustomerID is in cell A4 and UnitPrice is in cell D4. I've tried two different formulae, but neither of them worked. Does...

<tbody> Name Sales Sales Code Phil 1 £123 10 Phil 2 £123 12 Phil 3 £123 22 Phil 4 £123 20 </tbody> Thank you in Advance! As part of larger sumifs formula I want excel to do the following. In column A is a list of names, in column B is their sales for the month figure...

I am trying to have a rolling sum to calculate based on the account type and include today and previous dates - I cannot get the SUMIFS function right (or if this is even possible): =SUMIFS(E:E,F:F,"8948",A:A,">=Today()") <style type="text/css"><!--td {border: 1px solid #ccc;}br...

I am unable to get sum total for the following dataset: the columns are as follows: NO. PAYMENT AMOUNT INTEREST PRINCIPAL (D11:D1054) DATE WHEN PAYMENT IS DUE (I11:I1054) MY FOLLOWING FORMULA FAILS AND I AM OUT OF LUCK! =SUMIFS(D11:D1054,I11:I1054,"YEAR(2017)") I AM TRYING TO CALCULATE...

Hiya, Is there anyway I could tidy up/reduce this formula to still get the same outcome? I'm basically trying to sum up all the cells across multiple columns where the criteria matches the content of two seperate cells in another worksheet. Example: Based on the two sheets below - I wanted...

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <tbody> #D9D9D9[/URL] "]Name #D9D9D9[/URL] "]Tx #D9D9D9[/URL] "]Product #D9D9D9[/URL] , align: right"]Price #D9D9D9[/URL] , align: right"]Fees #D9D9D9[/URL] , align: right"]Total John Purchase...

Hi, Any help greatly appreciated as I cannot get my head around this formula. Basically I am looking to create a sumif where the months below are within a drop down menu and when this changes month the data will update to marry the month selected? I have a separate sheet saved with all the...

I am very new to coding in excel and I've run into a problem. I have created a workbook to help me log and run data on my internship hours. I have to have them organized by semester and also by standard (there are 6), however some activities include more than one standard, so I have a multi...

Hello, I have the date below (just a sample). I used =SUMIFS(Count_of_date,client,"Bronx-Lebanon",day_of_the_week,{"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"}) to try to get the subtotals for each day of the week on column E and then I would divide that subtotal by...

Hi all. I hope you are well and that you can help. I have a SUMIFS formula and it is not working correctly I was hoping that perhaps you may be able to help. My Formula is this =SUMIFS(C4:N4,C4:N4,C4<=11,C4:N4,F4<=1,C4:N4,I4<=1,C4:N4,L4<=1) But it is returning a value of 0 it should be...

Hi, Appreciate your help for below data; A B D 16030001 CTC BY 7TH 100.00 16030002 TS PERDIM BY 7TH 200.00 16030003 TS BY 7TH 300.00 TS SHELL 100.00...

Is it possible to look for a specific column based on a column criteria and sum the column up to a specific row based on a row criteria? <tbody> Jan Feb March April Yr. 1 10 20 50 70 Yr. 2 40 80 60 20 Yr. 3 30 10 80 40 Yr. 4 60 30 20 60 </tbody> Month = March (Column criteria)...