Todays ms excel lesson 22-11-2011 (conditional sum )

 

CONDITIONAL SUM FUNCTION IN EXCEL

Purpose:

During one of our previous posts, we have learnt how to use Sum-if function. This conditional sum function helps us to add the data based on the conditions that are met for more than one column. Unlike Sum-if function, which can add up the data based on the criteria given in one column, conditional sum function can add up the data based on the criteria given in various columns.

Input Data:

 

 Now if you would like to find out the total hours spent and the bill amount for critera where Mr Ashok has spent for Client Gary Ltd for the services Consultancy and Representation, you need to use this conditional sum

 How to do

Where do I find “conditional sum” in Excel 2003 / 2007 / 2010

In Excel 2007 and 2010 conditional sum wizard has been done away with. However, we can type the formula as per the format mentioned below:

Syntax of the formula

={SUM(IF (CRITERIA 1, IF( CRITERIA 2, IF( CRITERIA n, SUMRANGE)))}

 

Click Here to Continue Reading

Replies (2)

good work.

Here we can use SUMIFS function also which allows the same in more easy way.

thanks for sharing all these things.

JMD

I think it is possible through Pivot table also.

Best Regards

HS Negi

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
Featured ARTICLESHIP 17 November 2026
Associate/ Article Trainee

M/s. A V C & Co.

New Delhi

CA Inter

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
21 November 2026
Asst. Manager / Deputy Manager

Aco Perfumes & Cosmetic Pvt Ltd

Mumbai

CA

View Details
Company
ARTICLESHIP 20 November 2026
Article clerk

Jain Sanjay Kumar & Co

Jaipur

CA Inter

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details