EXCEL KE ADVANCE FORMULAS JARUR SIKHO

DOSTO FOLLOW JARUR KARNA

Chaliye Doston Is Class Mein , Main Aapko Kuchh Advance Formulas Sikhaunga Jese Countif,Countifs,Sumif,Sumifs,Average,Averagif,

Averagifs, Informal Ki Sahayata Se Aap Advanced Excel Tak Jaldi Pahunch Jaenge

 Jo Bhi Formula Excel Mein Use Kiye Jaate Hain Sabse Pahle Is Equal To(=) Ka Sign Aata Hai

Countif(Data Range,What Count)

Countifs(Result Row Select, Row Range 1,Single   Criteria Select,Row Range 2,Single Criteria Select)

Example

Countif(A1:D10,"Ram")

Countifs(D2:D10,B2:B10,"Ram",C2:C10,"Math")

Sumif( Select Row Range,Single Criteria,Result Range)

Sumifs(Result Row Select, Row Range 1,Single Criteria Select,Row Range 2,Single Criteria Select)

Example

Sumif(B2:B10,"Ram",D2:D10)

Sumifs(D2:D10,B2:B10,"Ram",C2:C10,"Math")

Averagif( Select Row Range,Single Criteria,Result Range)

Averageifs(Result Row Select, Row Range 1,Single Criteria Select,Row Range 2,Single Criteria Select)

 Averageif(B2:B10,"Ram",D2:D10)

Averagifs(D2:D10,B2:B10,"Ram",C2:C10,"Math")

Doston Yah Inke Formule Hain Jitna Ho Sake Aasan Tarike Se Maine Aap Ko Samjhane Ki Koshish Ki Hai

 

 

 

DOSTO YE CLASS CONTINUE JOIN KARTE RAHO AUR SABHI KO YE FREE CLASS KE BARE ME BATAO TAKI SABHI  SIKH SAKE AUR KOI PROBLEM ATI HE TO MUJHE COMMENT JARUR KARNA  (PLS 🙏🙏SHARE KARNA AUR MUJHE FOLLOW JARUR KARNA DHANYAWAD🙏🙏)

APKA MERE PAGE PE ANE KE LYE DHANYAWAD  

LINK :- ADVANCEBANO.BLOGSPOT.COM

BY-AAKASH