#sumif

Hi all, can anyone please help me to write VBA code or Excel formula? I need to sum up the Qty if the Supplier and Size matches and to have it in Result Worksheet. Thank you in advance.

Hi, I have a problem combining a SUMIF and SUBTOTAL formula into one formula, so i only get the "shown" filtered rows summed when criteria is met. I hope you can help? =SUMIF($D$5:D25;”Small";E5:E25) =SUBTOTAL(9;E5:E25) $D$5:D25 - is the range to look for the word “Small” “Small” - is...

I have three columns in which I want sum value of col3 based on col1 and col2 value if col1 = 1 and col2 = 40 then sum all value of col3 but if col1 = 1 and col2 = 20 or col1 = 2 and col2 = 40 then sum col3 value according to the col1 and col2 value for this purpose I am sharing the link of...

Hi everyone - I have been trying all day but I can't seem to find a way to make my formula repeat after a criteria is met. Please see screenshot. Situation: I have a table. in column [Cogs Value] you see prices of ingredients that I want to sum. in column [subrecipe name] you can enter any text...

Hi, Im stuck with a formula can anyone help? I want to sum the bottom row in the image below when two criteria is met, which is 'A' and 'Qty' The problem is the sum range needs to be the bottom row only(figures). The criteria 1 (A,B,C) is a merged cell if that makes any difference! Any ideas...

Hi all, The titles says it all. I would like to get a sum value via lookup based on if the text thread matches my search criteria. Below is an example of what I would like to do! <tbody> <tbody> Placement Name </tbody> <tbody> Spend </tbody> <tbody>...

I need to 1. Find the MAX of students on 2 variables. (course and country), 4 countries x 3 courses, so there are 12 MAX answers. 2. Filter the data to only include dates in say 2015 using a "timeline" slicer (not all) 3. SUM the results of step 1 filtered by step 2, this time...