# sumif and countif

1. ### Count based on multiple criteria

Hi I am trying to find Table1[ID] that matches with Table7[Name], "Singer" The only way to find this is if Table1[ID] = Table7[IDs]) and Table7[IDs] = Table7[Name], "Singer" but it keep showing error when I try to count it, how do I go around this?
2. ### If Range (A1:A15) = "x" then add all of B1:B15

Hi, I need help with a formula and keep getting Spill errors. What I am trying to do is say if the range A1:A100 = Anthony and E1:E100 = 1 (on another tab) then add H1:100 (on that other tab) that meet that criteria and divide by B15 on tab where formula is entered. Basically I need this...
3. ### Sum unique values with multiple criteria

Hey all, I am trying to create a formula in the that only sums the first unique value in column B but I need this sum to include a secondary grouping criteria which is column A (so only sum unique values for the Apple ground and then only sum unique values for orange and so on). I am not quite...
4. ### Sumifs+index formula help!!

Hello , NEw to this forum and would to get help(first thank you in advanced)!! I need help to create a formula that sum the following Summary below? <colgroup><col><col><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody> </tbody>
5. ### Counting unique value with a date range

I have a sheet with 60k+ lines of date for orders and I am wanting to pull the number of orders with a given date range based on a class of order. For this one I will just use all web orders as what I am looking at. There are several columns of date but the relevant ones are Col B - date the...
6. ### Help with value error and external spreadsheet

I need help changing my countif to a sumif formula so that results are available when the worksheet is closed. My countif formula is simple and works fine when the sheet is open. =COUNTIF('[DISTRICT G.xlsx]DIST G ALL'!$N:$N,">0") I have tried: =SUM(IF('H:\Cm\pi\ps\ddr\[DISTRICT G.xlsx]DIST...
7. ### Count / Sum data from two different sheets

I have two worksheets Worksheet "ORDER" <tbody> A B C D E 1 Part Name Order 1 Order 2 Order 3 Order 4 2 Nut Bolts 1 1 3 Pistons 2 2 4 Hammers 1 2 </tbody> Worksheet "PRODUCTION" <tbody> A B C D 1 Part Name Stock Order To be produced 2 Pistons 1 3 Hammers 2...
8. ### Sum only the first instance of a number tied to an ID, and then only sum those that tie to a label criteria

Hello and thanks to anyone who can help! I am trying to: In cell B2, Look at column A7:A23, and only sum numbers in D7:D23 if they match what is in A2 But, I *only want the first instance* of the numerical value per project ID in D7:D23, because otherwise, I double count. For example...
9. ### Sum Multiple Columns with Multiple Criteria

Say I have the following chart (See below) and I'm trying to sum the regions that have product overlap. What type of SumIf or SumProduct formula could I use to accomplish this task? <tbody> Product # Region 1 Region 2 Region 3 Region 4 Region 5 Region 6 Region 7 Region 8 Region 9 1...
10. ### Countifs working with SUM/SUMIF

So, here is my conundrum... I am trying to summarize data by month, based on a couple of variables. Example: If the Value in a column is YES, and a value in another column is a specific month, then summarize the total dollars in a third column. Now, if I was only looking for the count of...
11. ### Vlookup needed?

Hi I need to summarise each of our suppliers invoices on a separate forecast/actuals tab. Can I use VLOOKUP for this? Example month .... <colgroup><col><col><col><col span="2"><col><col span="2"><col><col></colgroup><tbody> Date Type Description Total NET VAT Expected Income...
12. ### =SUMIF and =COUNTIF in the same formula

I am looking to create a formula using both the sumf and countif operators. Example, Column A contains store numbers. Column D contains deposit variances(positive and negative numbers). However, there is an entry for every store, every day, even if there is no variance So, what I am try to...
13. ### Sum values in one column until values in another column reach a certain value

I need to get the sum of the prices when the contract is ZS but need the sum per quantity of 10. So in this example, i need to find the sum of first 4 columns because that will make the quantity add up to 10. The problem is, i copy and paste in sets of data where the "ZS" contract will fill at a...
14. ### SUMIF using multiple worksheets

I have a statistics spreadsheet I've create that has 3 tabs--One a summary, and the other two running totals of reference statistics. I'm using a SumIf formulate to calculate the total time spent on each specific date from the running totals sheets. That amount then goes on to the summary sheet...
15. ### Is the sumif the best option?

Good Morning MrExcel! I am trying to get the syntax correct but I am not 100% sure the SumIF is the right command for what I am after or if it should be some very long if statement. I would greatly appreciate any insight you have: I think can do this with pivot charts to get the sum but I am...
16. ### SumIf function/VBA help

Hey Mr.Excel I currently working on a project there i need find the total effort of assignments. The effort is in a Excel ark. This is an example on the ark. <tbody> A B C D E F G ID Item Release PlanID OP Prio Effort X Product 20-1 10 Mads 1 10 X Product 20-1 10 Mads 1 5 X Feature...
17. ### Count workers hours: I think this is easy. I am just not seeing it!

Hi there, I created a workbook that I use as a schedule for all workers in my department. The department breaks out into 4 other sub departments. All employees are scheduled for either a 4 or 8 hour shift. I need to quantify the data in a number of ways, most of which I was able to write on...
18. ### VBA SUMIF with multiple criteria

Good Morning! I have written a sumif sub that summarizes "value" based off of the criteria in the three columns to the left. <tbody> Year Contract type Price Range Value Year1 A Twenty > 19 Year2 B Fourty + 45 Year2 C Twenty > 15 Year2 D Fourty + 50 </tbody><colgroup><col><col...
19. ### Count If Month is Current Month

Here is the Issue I have 3 Pie Charts, they are populated from a spreadsheet that has a Status page (pie charts are located there), and the status page is updated from 3 additional sheets from the spreadsheet. I need the pie charts to only update with the current month data only, the sums of...
20. ### Question on SUMIF vs SUMPRODUCT and how to return a total in one column based on values in other columns

I have a massive excel spreadsheet of data that contains thousands of URLS and web performance data. My table structure is: Col B = Microsite Col I = URLs Col S = Total Page Views I am trying get extract the total in range S3:S1048576 where the values in range B3:B1048576 = "xyz", and the...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back