AboutPricing

Get instant live Excelp expert help figuring out how to use a SUMIF formula

“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.
< Go Back

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

    i need to combined both my sumif formula and vlookup formula that i have in the file but separate
    Solved by D. S. in 13 mins
    I need the SUMIF formula, to do this: 1) If the letter in column A2:A5 is "A"... 2) The numbers in column B2:B5 will be added to the total, provided that... 3) The numbers in column B2:B5 match their corresponding number in column C2:C5
    Solved by T. E. in 25 mins
    I need a formula that combines two separate revenue calcs together: (1) SUMIF based assignment of revenue based on calendar month/year; (2) SUMPRODUCT with SUBTOTAL that sums revenue by category
    Solved by X. C. in 19 mins
    I am using SUMIF nested formula, and I need a way to dynamically reference a column on another sheet using a cell
    Solved by Z. Y. in 25 mins
    Greetings, I need help creating a sumIf and countif formula. Also need help interpreting the sheet. Will provide more information. Thanks!
    Solved by F. H. in 12 mins
    I need a SUMIF formula that can add totals of invoices due by week by department
    Solved by S. Q. in 27 mins
    i ama trying to formula of sumif in one column with multiple conditiions
    Solved by E. C. in 22 mins
    3.Using the range named TechCode , creat sumif excel formulas in these cells: I9: Count the number of cells made by technician 1. I10: Count the number of cells made by technician 2. I11: Count the number of cells made by technician 3. 4. in cell I14, crreate a COUNTIFS formula to count the number of calls made by technician 3 for which the hours logged were greater than three. Use range names ( TechCode and Hours) were possible. 5. Using the ranges named TechCode and LaborCost, create SUMIF formulas in these cells: I9: Add the labor cost for calls made by technician 1. I10: Add the labor cost for calls made by technician 2.
    Solved by I. Y. in 21 mins
    I HAVE WRITTEN A FORMULA FOR SUMIF AS FOLLOWS: =SUMIF(B6:B44,B48,AT6:AT46) the formula is returning only one value from the specified range. I have recopied the values in b6:b46 to eliminate any formatting issues. the formula is only returning one value from the sum range. the all the values in AT6:AT46 are arrived at via a formula. If i copy the info to another sheet without any formulas then I get the correct answer. I need to be able to use the sum of values that meet a criteria from b48 applied to range B6:B48.
    Solved by X. B. in 14 mins
    I need help with creating a formula to add values but excludes values when there is a certain value in another cell. i have tried the SUMIF but cant seem to get it!
    Solved by D. H. in 13 mins
    123467