sumif and subtotal

Hi, I have a very simple formula: =SUMIF(C49:C58,"James",A49:A58) The values in Column A are being pulled from another sheet in the same workbook and are correct. I've checked for any errors (like extra spaces) in Column C. Instead of summing my results, I keep getting 0. I tried pasting...

I'm recording income and expenses in a spreadsheet and I filter the not all of the transactions always appear. I have a subtotal that I want to display what the filtered income and expenses are. Right now I can only do a sumif for the total amounts, and not when the amounts are filtered. Is...

OK so I have: * column A which defines unit type * column B which defines 2 criteria (OPEX or CAPEX) * column C and onwards represents each calendar month and each line defines the amount of money that was spent I want to be able to record the total amount for each type of spend each month...

I have 1000+ rows in excel, in all rows of Column A there are only three texts that is "DEMAND" "COLLECTION" "BALANCE" I want to calculate the column F total based on the text of column A. for example 1 DEMAND 10 2 COLLECTION 20 3 BALANCE 50 4 DEMAND...

Hello, I have an issue with combining the formulas subtotal and sumif. I have read several solutions from here but none have worked... :( I have this sumif for skipping N/A values: =SUMIF(K38:K2366;"<>#N/A") and a subtotal for the same range, K38:K2366 would be required (sum). Also, as an...

Hi all, Long time lurker and first time poster because I always find my solution here. How ever I am trying to create a SUM/SUBTOTAL for my report so when I filter the results, the subtotal shows me only those results. this is my configuration. <tbody> ROWS Column B Column C Column D Column E...

I'm looking for a subtotal equation that I can use that sums a total column when filtered based on a criteria (sumif) for tbd. I'm currently using the following equation........=sumif($A:$A,"tbd*",B:B). The table below shows what I have when a filter is in place. Three names pop up when the...

Please help, I have been attempting to follow other posts to do this but have been unsuccessful. I need to combine the following two formulas: =SUBTOTAL(9,H3:H143) =ROUNDUP((SUMIF($E$3:$E$143,$F$158,H3:H143))/240,0) Column H are the values I want to subtotal based on if the value in F158...

I am trying to sum an inventory report which has the same product in different locations. The product is listed by product name and color. Column A = Brand Name Column B = Color Column C = Quantity Ex. Brand A Red 5 Brand A Red 7 Brand A White 8 Brand A Green 9...

Hello, I have a great SUMIFS formula that pulls from a drop down menu. I have multiple criteria and conditions well established, however if the criteria selection is "ALL" from the drop down list, I'd like to sum all those totals based on the other criteria selected. A. Joe's Totals B. Barb's...

Hi, I need some help please. I have trying to subtotal column Z for cells where column AA=No. The formulas work individually but I can't work out how to put them together in the one cell/formula. Currently using: SUBTOTAL(109,Z4:Z9600) SUMIF(AA4:AA9600,"No",z4:Z9600) But how do I string...

Hi all, I've been struggling with this excel problem for most of the day and I'm hope someone on this forum will quickly resolve the issue. My OS is Windows 7 and I am using MS Office 2007. I tried to upload the worksheet, but I can't download the add-in due to my office security. I have 3...

Hey Everyone, I have an Excel document with two sheets(tabs). One is called "AnalyseData" and the other is called "New Table". I want to get the total of values in column K in "AnalyseData" WHEN: Column F in AnalyseData = Cell D12 in New Table Column D in AnalyseData = Cell B2 in New Table...

I have built a model that is linked to a sheet of data. What I would like to do is let someone filter the data, say by state and then have the model change from showing all results to just those filtered results. The tricky part is that I need to use the countif and sumif functions to tell the...

Hi, I am having trouble combining the two statements below into one. =SUMIFS(N$7:N$26,$D$7:$D$26,"LC Approved",$L$7:$L$26,$L30) =SUBTOTAL(9,N$7:N$18) I need to sum column N. Any help would be great. Thanks.