Excel mein different data ranges par calculations ka matlab hai ki hum worksheet ke alag-alag cells ya ranges se data lekar calculation kar sakte hain.
For example, agar marks alag-alag subjects ke columns mein hain, to hum SUM, AVERAGE, MAX, MIN jaise functions ko different ranges ke saath use kar sakte hain.
| Calculation | Formula | Purpose |
|---|---|---|
| SUM | =SUM(B2:B6) |
Ek range ka total |
| AVERAGE | =AVERAGE(B2:B6) |
Ek range ka average |
| MAX | =MAX(B2:B6) |
Highest value |
| MIN | =MIN(B2:B6) |
Lowest value |
| Multiple Ranges SUM | =SUM(B2:B6,D2:D6) |
Do alag ranges ka total |
| Multiple Ranges AVERAGE | =AVERAGE(B2:B6,D2:D6) |
Do ranges ka average |
| Multiple Ranges MAX | =MAX(B2:B6,D2:D6) |
Dono ranges mein highest value |
| Multiple Ranges MIN | =MIN(B2:B6,D2:D6) |
Dono ranges mein lowest value |
| Student | Maths | English | Computer |
|---|---|---|---|
| Amit | 80 | 75 | 90 |
| Ravi | 70 | 85 | 80 |
| Neha | 95 | 90 | 85 |
| Pooja | 85 | 80 | 95 |
Agar Maths aur Computer ke marks ka total nikalna ho:
=SUM(B2:B5,D2:D5)
Agar dono ranges ka highest mark find karna ho:
=MAX(B2:B5,D2:D5)
Agar lowest mark find karna ho:
=MIN(B2:B5,D2:D5)
Different Ranges → Function Select → Required Cells Select → Calculation → Result
Example:
B2:B5 + D2:D5 → SUM → Total
Different ranges ko select karte waqt comma , ka use karke multiple ranges ko ek formula mein include kiya ja sakta hai.
Easy Memory: Ek formula mein multiple ranges ko use karke hum alag-alag areas ke data par ek saath calculation kar sakte hain.
Leave a Reply