How to use SUMIFS formula in excel Hindi

In this tutorial, I teach you how to use sumifs formula in excel.

This formula comes into the advance excel category. we use this formul when we want to sum with more than one condition.

Adds the total of cells in a range based on multiple criterion. Improved audio quality.
SUMIFS formulain Excel sums cells in a range that match supplied criteria. Unlike the SUMIF function, SUMIFS function in excel can apply more than one set of criteria, with more than one range. The first range is the range to be summed. The criteria is supplied in pairs (range/criteria) and only the first pair is required. For each additional criteria, supply an additional range/criteria pair. in Sumifs formula in Excel Up to 127 range/criteria pairs are allowed.

Note that the order of arguments is different between the SUMIFS formula and SUMIF functions. Sum_range is the first argument in SUMIFS function in excel but the third argument in SUMIF.

[HimachalNewsUpdates]

Valuable information in short time.
Thank You

[kaminidhiman]

Thanks no bakwas bus fatafat btaya apne ye hi chahiye tha

[MarghubAlam]

Interesting, helped me to save lots of time minutes. Thank you for this quick video guidance.

[MohitKumar-iwio]

Sir i like your video very much thank you so much 🙂

[lalbabukurmi]

try to give the excell file in the description so, that your viewers can practice on it .

[mentalcase]

How SUMIFS condition apply in MS Excel 2003 version ?

[antaramalis]

If there is filter option pls explain why the use of sum ifs

[sudhaaneja]

Can employee , sales,sr no., religion data be use for vlookup pls reply too me

[garvitarora]

Agar sales calculate karni ho aur condition ho ki north and east ki karni hain toh kaisi hoga?

[rajkumarpatel]

Agar sum_range do row me rhega to Kya karna hoga

[syedimran]

Dear Sir agar hamari sum rang 2 hon to phum kya kare

[abhishek]

Sir abhi bhi mujje ye smj nhi aya ceritria 1 aur Ceritria 2 kon sa dale kiya pachana ha iski

[alishashanu]

M if k formula m bhut confused hu plz help