# How to check a list for a value and then sum all amounts where value is the same

1. ## How to check a list for a value and then sum all amounts where value is the same

Hi all,

I'm trying to sort my finances out and as a result I'm categorising my spend on my credit card.

As a result I have a very long list of items with a description (A) Category (B) and value (C)

I want to be able to total the items in the list from a certain category

For example
Tesco - Petrol - £50
Tesco - Food - £30
Tesco - Petrol - £60
Tesco - Food - £50
Tesco - Petrol - £40
Tesco - Food - £60

Total Food = £140
Total Petrol - £150

What forumlar would work to review everything in a list of 300+ lines to check and sum all of these

Thanks in advance for the help

2. ## Re: How to check a list for a value and then sum all amounts where value is the same

This maybe?

=SUMIF(B:B,"Petrol",C:C)

3. ## Re: How to check a list for a value and then sum all amounts where value is the same

The formula you're looking for is SUMIF:
``Please Login or Register  to view this content.``
That should be what you need, or at least close

4. ## Re: How to check a list for a value and then sum all amounts where value is the same

Great. that worked a charm.
Now exploring that further is it possible to search Date range (D) as well?
So for example check date and if it's in the month of April or range say 1st April to 31st April to do the same?

5. ## Re: How to check a list for a value and then sum all amounts where value is the same

That would be SUMIFS(): https://support.office.com/en-us/art...6-611cebce642b

Or, this starts to feel like a pivot table would be a useful (maybe better) way to summarize the data: http://www.excel-easy.com/data-analy...ot-tables.html

6. ## Re: How to check a list for a value and then sum all amounts where value is the same

Thanks everyone for your help! Great forum!

7. ## Re: How to check a list for a value and then sum all amounts where value is the same

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