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
The following formula is repeated on multiple rows. Would it be possible (and efficient) to turn it into an array formula? I'm working in Google Sheets but I presume the same principles apply... =round(if(C43="",sumif($B44:$B94,$B43,F44:F90),iferror(VLOOKUP(C43,indirect("'"&B43&"'!B$13:D$58"),3,FALSE),"")),0)
Solved by X. C. in 17 mins
Hi there. Please could you help me to turn this formula into an array formula to be used across the range C43:C450
=round(if($C43="",sumif($B44:$B90,$B43,AA44:AA90),SUMIFS(Cashbook!D:D,Cashbook!K:K,B43,Cashbook!L:L,C43, Cashbook!T:T,"")+SUMIFS(Cashbook!H:H,Cashbook!K:K,B43,Cashbook!L:L,C43, Cashbook!T:T,"")),0)
Solved by C. C. in 15 mins
I need a formula that when column J5 is Yes or Y, that it sums columns E5 through H5. I write the formula for sumif, but the answer always ends up as 1, instead of adding up the actual sum of the numbers.
Solved by E. W. in 20 mins
Need help creating a more efficient worksheet with the data provided by using a vlookup and sumif formula.
Solved by S. A. in 30 mins
I have an Inventory table.
I have a Starting Qty column, then I have a Qty In Stock column - this is the column I want automatically updated. On another worksheet I have a column of all the inventory, then other columns for all the job orders that are being done. I have a SUMIF formula that works perfectly - however, it's only adding the first column (the first job order)...I need it to add the inventory from every other column (job order). I have tried everything and can't get it to work. I would have thought simply highlighting the rows would work but it isn't. I know this is a really simple fix. Files won't upload!
Solved by M. Y. in 21 mins
Hi I am trying to combine a sumif and a vlookup and struggling!
I would like to do the sum of a column if it meets one criteria and can successfully complete the formula but I would also like it to divide each of the cells in the sum range by the rate of exchange in another table the currency for each row of the figures to be added up is in a column to the left...
Can you help please?
Solved by O. J. in 25 mins
how to sum in excel? I need to find the total of list with mutiples conditions.
Solved by X. H. in 29 mins
how to use sumif on excel?
Solved by T. W. in 19 mins
Can you provide some excel sumif example? I want to understand the function and how to apply with mutiple conditions
Solved by Z. Q. in 14 mins
how to do a sumif in excel?
Solved by O. Q. in 28 mins