# Excluding or Including numbers in totals

1. ## Excluding or Including numbers in totals

Hello Everyone,

I hope you can point me in the right direction here, my understanding of Excel is very basic so I don't really even no how to research what I am after.

Problem.

I have a workbook which for the most part consists of simple adding up of numbers. On one worksheet I have some fixed figures, that I'd like to have the option of excluding from the total, I could just delete the figure, but they need to be there as a reference, I'd like to be able to experiment with different budgets by excluding and see the end result in the Gross Profit total.

I was using a formula like this =IF(D5="Y",0,E5) This then reads the figure in E5 and includes it in the totals column.

It comes undone when you attempt to calculate the totals column and then take that total away from a known sum - the Gross Profit. I can't find a way of producing a gross profit minus only included figures, of if I do, I end up with tangential results depending on the conditions of previous cell Totals.

I won't over detail the problem unless you need me to, my intuition is this must be a fairly well known and simple process, that perhaps I just need to read the right page on. Logic like this is not my strong point its probably insanely easy!

Many thanks,
Jon

2. ## Re: Excluding or Including numbers in totals

Welcome to the forum.

You need to look at the SUMIFS function: https://exceljet.net/excel-functions...umifs-function

Give us a shout if you can't get it to work for you.

3. ## Re: Excluding or Including numbers in totals

Thanks Ali, will check it out now

4. ## Re: Excluding or Including numbers in totals

Let us know how you get on.

5. ## Re: Excluding or Including numbers in totals

Yep, worked a treat, thanks again.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1