Conditional Sum Using Filters

Last updated at April 16, 2024 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
Go Ad-free
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant for the past 14 years. He also provides Accounts Tax GST Training in Delhi, Kerala and online.