Conditional Sum Using Filters

Last updated at August 5, 2026 by

 

What are Filters

Filter are small button at top of column

It is used to analyze individual items in a data (example count/sum etc)

Earlier we learnt how to Count using Filters

Now,we calculate Sum or Total Using filter

 

 

Assignment

Calculate Sum of following using Filters

Conditional Sum Using Filters - Sumif and Sumifs

 

Q1 FIND THE TOTAL BASIC SALARY OF DELHI EMPLOYEES

View Answer

Q2 FIND THE TOTAL BONUS PAID TO GURGAON EMPLOYEES

View Answer

Q3 FIND THE TOTAL GROSS SALARY OF NOIDA EMPLOYEES

View Answer

Q4 FIND THE TOTAL GROSS SALARY OF NOIDA EMPLOYEES COVERED UNDER ESI?

View Answer

Q5 FIND THE TOTAL NET SALARY OF DELHI EMPLOYEES HAVING BONUS >10000?

View Answer

Q6 FIND THE TOTAL PF OF DELHI EMPLOYEES HAVING BASIC >20000?

View Answer
Remove Ads
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant with 16+ years of practical experience and 20+ years of teaching experience. At Teachoo, he simplifies Accounts, Tax and GST with step-by-step examples so students can apply concepts confidently in exams and real life.

For an uninterrupted learning experience, students can use Teachoo Black to remove ads and focus better.