Get instant live Excel expert help figuring out how to use SUMIF

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I work for a newspaper. We have a storylog with a batch of URLs but its missing google analytics data. The google analytics data has been imported on another sheet, but I need to be able to merge data using a common URL. The main problem is that analytics pulls tons of duplicate strings..... e.g. www.mywebsite.com/ and then www.mywebsite.com/index~214. When I try to use a SUMIF function, it only sums the exact matches "www.mywebsite.com/". I've tried with approximate matches, but nothing seems to work. Please help!
Solved by S. C. in 22 mins
I have a source data sheet and I working on a summary sheet to pull data together. e.g.: Summary Tab Date range; 1.7.17 - 31.7.17 Shirts Dress Skirts On source document - I have individual lines which are coded to the above categories and other sub-categories, with delivery dates. the source doc dates range over 12 months I want to be able to paste in updated source data & have the summary page update - changing the date range above to move through months. The basic category SUMIF are fine. But when I need to sort by both the Category & then again by sub-cat I get error. I also need a formula that adds up only the numbers in that category with a delivery date within {that range}?? Can you help?
Solved by X. H. in 29 mins
I have 10 worksheets that have identical row names and content. The columns are all dates. But each worksheet has a different date in column B. I want to consolidate those 10 worksheets into a consolidation tab such that the values in the columns will sum in the consolidated sheet based on matching up the specific date. The columns are headed with date values. I am trying to use the sumif function based on the criteria that the dates in the worksheets exactly match the date in the consolidated worksheet. Help
Solved by C. H. in 24 mins
Sum of data by product using a lookup value - i've got a complex sheet where i need to do a summary by product type but it's got to get the values from a lookup and i cant get my head around the calculation. I think its a sumproduct and sumif but the calculations just not working for me. can you help?
Solved by B. B. in 21 mins
I have some data I wish to sort into a list BUT… in column A are vendor names vertically i.e Tradesmart and then horizontally across the top are individual project numbers in each column. Horizontally some projects have different costs for the same vendor. What I need to do is get a list which has the vendors in column a and the costs in column B, if the vendor has two projects with costs then it needs to appear twice with the different costs. For example: If Tradesmart has costs in project 1235 and 1245 then it should appear as follows in column A and B as follows. Tradesmart £50 Tradesmart £60 If I use a Hlookup it will simply pick the first cost it finds for that vendor and If I use a SUMIF it will sum a total under one vendor but I need it split out and to repeat the name if it appears under several project numbers. It could very well be that some vendors only have one cost under one project in which case making a list wouldn’t be an issue. Also one step further would be to put the relevant project number in column C next to the corresponding Vendor and cost. This is simply rearranging the way the data appears but right now I’m having to do this manually and its taking a very long time. Any help someone can offer would be highly appreciated.
Solved by Z. Y. in 11 mins
Hi I'm having issues with SUMIF's can you please help me?
Solved by K. U. in 22 mins
need help with sumif to be used on multiple sheets
Solved by F. Y. in 22 mins
For the midterm project you will design and create a workbook. The workbook should help solve some problem or serve a purpose that is of personal value to you, a friend or an associate. Create a short description of the workbook you plan to create as descrbied in Part I of the project. Keep in mind that your workbook must implement the technical requirements described in part II. CS302 Midterm Project Part I: Write a description of the Excell workbook you plan to create. Be sure to choose a project concept that will be of personal use to you, a friend or work associate. Preview your description with your instructor for approvail before proceeding to part II In your description include the following: 1. Who will use the workbook 2. Describe what the workbook will do (What purpose will it serve?) 3. Describe the type of data that will be stored in the workbook 4. Describe some of the analysis and reporting features of the workbook. Midterm Project Part II: Create the workbook to complete your project. Your workbook must implement the following technical requirements. 1. Well formatted with some background color, borders and style 2. Contain at least one database sheet with at least 15 records and 4 fields of data and at least one calculated field. 3. Apply appropriate named cell references to your workbook. 4. Implement goal seek analysis using absolute cell references and an assumption area. 5. Use conditional formatting on the database sheet. 6. Use two or more of the functions from this list: if(), iferror(), sumif(), countif() 7. Use a database lookup function like VLOOKUP() using a lookup table. 8. Create a filter sheet that will demonstrate the use of numberic and text filters applied to your datasheet. 9. Create some scenarios and generate a summary report. 10. Add at least one macro with a button to run the macro. 11. Use solver in some way. Be sure to create an answer report. 12. Add appropriate and consistant data validation fields 13. Create 2 charts of different styles using different data. Include examples of data labels, modify axis settings, legends and titles. 14. Add an imbedded image with a link to a web web site. 15. Add cell and worksheet protection. Highlight the unprotected cells. Make the password "MIDTERM". 16. Be sure to add comments to your project workbook pointing to each of the requirements above. Include the requirement number as the first line in the comment. The comment should point to where you implemented each of the technical requirements. To add comments right click the cell and select the insert comments menu option. 17. Add a sheet to your finished workbook named INDEX. The INDEX will list each of the technical requirements above. The INDEX sheet should be the first sheet in your sheet tab. In the A column of the INDEX sheet create a list titled 1 thru 16 matching up with the 16 technical requirements. Add a hyperlink so that when the instructor clicks on the link it will goto the worksheet and cell containing an example of the technical requirement. In the B column add a short description of your implementation of the technical requirement. This is required for grading purposes. If these hyperlinks are not added to your workbook it will affect your project grade. Submit your description document and project workbook for grading.
Solved by C. J. in 23 mins
If in the Sheet1 column H4 I have the following formula: = SUMIF ($B$4:$B$30,G4,$C$4:$C$30) So how to write the formula in the code? Please help.
Solved by D. W. in 17 mins
Need help summing a column of numbers compared against a cell in that column, then iterating through the column, comparing each cell. Using a sumif statement
Solved by V. H. in 11 mins