Get instant live Excel expert help with SUMIF functions
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
trouble with sumif function - if a cell equals 'Yes' then cell d90 * 15
Solved by F. S. in 25 mins
Hi,
Need help with a SUMIF formula, I cann
Solved by Z. A. in 23 mins
I have a data table, one column is months.... Hundreds of rows for each month. Each row contains a different item number. I am trying to consolidate to another table, by month, by item number. I know it is 2 hypotheticals, maybe a sumif... Help
Solved by O. J. in 11 mins
How many arguments are required for a SUMIF function?
Solved by C. E. in 26 mins
I am looking for the Sum of all products.
cell A9 is a macro which adds product A,B,C and i've added a formula which doesn't calculate correctly.
formula is
=SUMPRODUCT(SUMIF(Products,TRIM(MID(SUBSTITUTE(A9,",",REPT(" ",LEN(A9))),1+(ROW(INDIRECT("1:"&LEN(A9)-LEN(SUBSTITUTE(A9,",",""))+1))*LEN(A9))-LEN(A9),LEN(A9))),F3))
Solved by C. A. in 23 mins
Excel file has a running time stamp. Each column coincides with a particular variable. Values (across different rows) for these variables changes throughout the document. What I'd like to do is sum up the time elapsed for when a certain value occurs, i.e. if the value occurs across a span of 5 min and then a span of 15 min later on, I'd like to sum up those values.
Working with ~60,000 rows, so I'm trying to find an equation that will work. Tried SUMIF, but it just sums up hr:min:sec without taking the difference between start and stop times for a certain value.
Solved by T. H. in 23 mins
I have to find the total years of Java experience for all the consultants in this table but I don't know how to properly execute the SUMIF function.
Solved by E. H. in 14 mins
Question on a SUMIF formula: =SUMIF((H6:H494),">01/01/2017"and"<10/31/17,I6:I494) is not working for me.
Trying to use sumif date range for all sales numbers within a date range of one month. Thank you
Solved by G. D. in 14 mins
I'm looking for an easier way to do a SUMIF for each week of the year without having to directly reference each week by putting for example ">=1-1-18" "<7-1-18" , is there an easy way to do this?
Solved by F. A. in 27 mins
Using Microsoft Excel Index function, Match function, CountIf function, SumIf functions and Pivot Tables, please answer the question in data sample.
Solved by A. H. in 27 mins