Multiple lines of data need to lookup and sum

[rentonhighlands]

Hello,
I have a sheet that has multiple lines of data. What I need to do is lookup per address and sum together the cost per address to add the data to another sheet.

Example

address	Service Type	Cost Each
751	Access	2519.95
751	Access	2162.35
751	Port	906.99
751	Port	0
751	Port	906.99
751	Port	0

 

[Fluff]

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Sounds like you need SUMIFS SUMIFS Function

 

[rentonhighlands]

version 2409
How do I do a lookup from the other sheet and sumifs together?

 

[Fluff]

version 2409

That is the build version, we need to know the product version, ie like 2016, 2021 365 etc.

You don't need to use a lookup, the sumifs will do that.

 

[rentonhighlands]

365
Please write and example of sumifs for me to see

 

[Fluff]

The link I supplied does all that.