Search and consolidate multiple values in multiple fields

[Chrissy1818]

Hello

Wondering if anyone can help me come up with a formula. Basically I wan
a single cell to search a worksheet for different information and spi
out the total sum of that corrosponding "number". I attemted
consolidate and a sumif but it won't look for the multiple values tha
im after.

Basically I have a table of budgetary costs broken down into su
sections - however the report that I run breaks these down even furthe
into individual codings. I want to be able to search for codes 5111000
5113100,515000 etc and have it return the sum amount of all those code
into the table ive created that just has the sub section (summarises th
costs). As there is multiple users and it is a copy and paste excercis
the data will not be in the exact same corrosponding line every time
i.e code 5111000 could be in cell 1 on sheet 1 but on A48 on Sheet to
I need it to search that whole section for the correct number and the
the amount in the cell next to it.

I hope this is making sense!! Been looking for something that can d
this and unfortunately I can't write macros!!

Thanks - Chriss

 

[Spencer101]

Hello

Wondering if anyone can help me come up with a formula. Basically I wan
a single cell to search a worksheet for different information and spi
out the total sum of that corrosponding "number". I attemted
consolidate and a sumif but it won't look for the multiple values tha
im after.

Basically I have a table of budgetary costs broken down into su
sections - however the report that I run breaks these down even furthe
into individual codings. I want to be able to search for codes 5111000
5113100,515000 etc and have it return the sum amount of all those code
into the table ive created that just has the sub section (summarises th
costs). As there is multiple users and it is a copy and paste excercis
the data will not be in the exact same corrosponding line every time
i.e code 5111000 could be in cell 1 on sheet 1 but on A48 on Sheet to
I need it to search that whole section for the correct number and the
the amount in the cell next to it.

I hope this is making sense!! Been looking for something that can d
this and unfortunately I can't write macros!!

Thanks - Chrissy

Hi Chrissy,

There are several ways to do this but which will suit you best very muc
depends on exactly how your data is set out and which version of exce
you are using.

Any chance of a sample workbook?

If you cannot post it here, feel free to email it to me on pubnut
gmail . Com (with no spaces) and I'll happily have a look from there.

S

 

[Chrissy1818]

Hi Chrissy,

There are several ways to do this but which will suit you best very muc
depends on exactly how your data is set out and which version of exce
you are using.

Any chance of a sample workbook?

If you cannot post it here, feel free to email it to me on pubnut
gmail . Com (with no spaces) and I'll happily have a look from there.

S.

Hello

It wouldn't let me post it so I will email it through.

Thanks for tha