Add numbers based on criteria from specific cell on same row

Hi Guys,

I'm looking for a way within excel to add data based on a cell's criteria. I have certain account numbers, they're not traditional numbers such as 1,2,3, they have dashes in them. Below is how the data looks.

A B C D
6311.100 expenses 01-174-6311.100 1000
6311.200 expenses 01-174-6311.200 2000
6311.300 expenses 01-174-6311.300 3000
6311.400 expenses 01-174-6311.400 4000
6311.500 expenses 01-174-6311.500 5000


This is just an example of how it looks, I've added 4 columns, I want to be able to sum up the numbers from column D(1000,2000,3000) based on column C's numbers. So let's say I want to add all cells from 'column D' that have "column C" range of "01-174-6311.100 - 01-174-6311.400". How would I go about doing that. If it's done correctly, it would add 1000,2000,3000,4000 since those are the only one with their 'column c' data falling between "01-174-6311.100 - 01-174-6311.400".

To sum it up, all cells from 'column d' who's cell from 'column c' falls withing the given range would be added, and anything out of the range would be skipped. So for the first row, before deciding if 1000 should be summed up, "cell C(01-174-6311.100" would be checked to see if it falls within the range. For the second column, before deciding if 2000 should be added, "cell C(01-174-6311.200" would be checked.

I would much rather use a function within excel if that's possible, if not, I'll try a macro code.
data.png

Thanks in advance for any help!

The formula gives total from 200 to 400 (values can be changed).

Please Login or Register  to view this content.