How to Sum Multiple Columns Based on Multiple Criteria | MS Excel Tutorial | Excel Formulas

#MSExcel #ExcelTutorial #ExcelFormulas #ExcelFunctions

[nedaari]

Perfect! I was looking at Vlookups and Indexes. This was it. Thank you!

[rahul]

No 1 formula sir ...I have solved my big calculation after finding your formula.. 👍 thanks

[crownedtalks]

Hi what formula can I use if eg a staff member pays for his policies and I need to. Match that amount to the unique policy number
Eg staff member 101011
Amount 100=
20 to policy 123
40 to policy 356
10 to policy 673
30 to policy 471

[miibos]

This is great but it didn’t work for me because my table has text in it

[harsinchh]

How sum if
A B C
20 30 40
10 50 90
40 60 30
70 30 60
In the above eg. I want a sum of column C from the Min or Max value of column A or B. As A2 has the first occurrence of min/max value so from there I want the sum of C column (90+30+60) C2 - C4.
Please help with this question.

[lasa]

if Boss wants to select the specific months dynamically based on cell value ??

[kamran]

How is it possible to do this with a specific date range, that is in another cell?

[PrincipalSphoorthy]

how can i use wild characters in condition, for example instead of (-- a7:a45=a3 ) can i write (-- a7:a45="z*") or (-- a7:a45="a*") so that my result will be supplier name staring with z ( in this case zahid group) or supplier name starting with a ( in this case arabian parts company and Alibaba co) it is not working when i use wild character, can please help

[modestakerketta]

If you add month as creteria, how to get cumulative till selected month in drop-down

[muhammadandrialisraqi]

what is the short formula?
because the formula is too long

[eeentertainmentandenjoymen]

Sir I have if condition applied different amount columns(20) and I want their(diff clmns)last sums in a single cell...is it possible sir....pls help me

[Infotainment_official]

Thankyou very much for this video. I have a problem if you help in solving then I share it with you

[kuunami]

I'm just trying to create a dropdown list that returns the sum of any column that's selected in the list.

[Infotainment_official]

I have a purchases from April 20 to December 20 from different GST suppliers. I want to get consolidated result on the basis of GSTIN no for specific months. Kindly if you can solve it.

[karunakarvemishetty]

Hi Sir, for me its not giving answer for there single column.... kindly help me sir....

[sherinjosephvarghese]

Thanks a ton for this - however - How can i have a date range for example Jan to March and the result is given

[harsinchh]

Sir,
A B C
20 40 30
(10) 50 [60
20 30 20
50 10 10
60 10 80
30 (90) 50]
20 20 70
From column A min value 10 to column b max value 90, how can I sum column c all cells from min value to max value at column A to column B.

[babarburrak]

dear apko file b sath datni cahya i repeat you shoult also attach the prective file as well

[eeentertainmentandenjoymen]

Sir ie I simply want to get the sum of last cell of multiple columns(20) in a separate cell..pls pls pls help sir

[HiHi-kcef]

How about more than one part e.g tyre and wiper?