# Consolidate

1. ## Consolidate

i have a worksheet seperated by columns:

DATE / VENDOR / DESCRIPTION / FILE / MONTH / AMOUNT

i hope i explain this properly. i would like to cosolidate vendors. if there
is a vendor that shows up multiple times than i would like it to cosolidate
the name and just show me a total for that vendor for each month. i have at
least 30 vendors and over 1000 row of data. is this possible.

2. ## RE: Consolidate

You could use SUMIF function in a separate worksheet, or to one side of your
existing worksheet, firstly though it may be better to make a unique list of
your vendors and use the SUMIF function to extract the data you need, e.g.

=SUMIF(rangename,vendorname,qty)
where rangename is the entire data set ( say A1:F1000 ), vendorname is the
column with the vendor names ( say B1:B1000 ) and qty is the amount column (
say F1:F1000 ).

"Michele" wrote:

> i have a worksheet seperated by columns:
>
> DATE / VENDOR / DESCRIPTION / FILE / MONTH / AMOUNT
>
> i hope i explain this properly. i would like to cosolidate vendors. if there
> is a vendor that shows up multiple times than i would like it to cosolidate
> the name and just show me a total for that vendor for each month. i have at
> least 30 vendors and over 1000 row of data. is this possible.

3. ## RE: Consolidate

i wrote this =SUMIF(Sheet1!A1:F1492,Sheet1!B1:B1492,Sheet1!F1:F1492) in
another worksheet but i get this " 0 " now i just wrote that function in
cell A1. do i need to write it elsewhere?

"John Moore" wrote:

> You could use SUMIF function in a separate worksheet, or to one side of your
> existing worksheet, firstly though it may be better to make a unique list of
> your vendors and use the SUMIF function to extract the data you need, e.g.
>
> =SUMIF(rangename,vendorname,qty)
> where rangename is the entire data set ( say A1:F1000 ), vendorname is the
> column with the vendor names ( say B1:B1000 ) and qty is the amount column (
> say F1:F1000 ).
>
> "Michele" wrote:
>
> > i have a worksheet seperated by columns:
> >
> > DATE / VENDOR / DESCRIPTION / FILE / MONTH / AMOUNT
> >
> > i hope i explain this properly. i would like to cosolidate vendors. if there
> > is a vendor that shows up multiple times than i would like it to cosolidate
> > the name and just show me a total for that vendor for each month. i have at
> > least 30 vendors and over 1000 row of data. is this possible.

4. ## RE: Consolidate

"Michele" wrote:

> i have a worksheet seperated by columns:
>
> DATE / VENDOR / DESCRIPTION / FILE / MONTH / AMOUNT
>
> i hope i explain this properly. i would like to cosolidate vendors. if there
> is a vendor that shows up multiple times than i would like it to cosolidate
> the name and just show me a total for that vendor for each month. i have at
> least 30 vendors and over 1000 row of data. is this possible.

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