if function
 

if I have 500 rows and several col

and lets say col B is office cities

IE Dallas, Fort Worth, Austin, Houston

and the col F
has sales totals
Is there a way I can subtotal the col f in setter work sheet
IE
if col b = Dallas, subtotal everthing that = dallas by col F

if function
 

You want a Pivot Table. You'll love them once you get used to them. Google
pivot tables for more information.

Regards,
Fred

"Dylan lotz" <Dylan lotz @discussions.microsoft.com wrote in message
...
if I have 500 rows and several col

and lets say col B is office cities

IE Dallas, Fort Worth, Austin, Houston

and the col F
has sales totals
Is there a way I can subtotal the col f in setter work sheet
IE
if col b = Dallas, subtotal everthing that = dallas by col F

if function
 

Hi,

Sort in ascending order on column B and then use Data Subtotal.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Dylan lotz" <Dylan lotz @discussions.microsoft.com wrote in message
...
if I have 500 rows and several col

and lets say col B is office cities

IE Dallas, Fort Worth, Austin, Houston

and the col F
has sales totals
Is there a way I can subtotal the col f in setter work sheet
IE
if col b = Dallas, subtotal everthing that = dallas by col F

if function
 

could you elaborate, Datasubtotal:

Please help

col b; has several city names, col c wiht emplyee names ect.

Then col F has the employess sales totals, we constanctly add employee lines,
so it would be much easier to say if colb=dAllas sum all totals associated
w/ col F.

My staff is not good enough to this in a pivot tabel. dont know is If I
could inorporate this in a =stringconcat vba formula to consolidate email
address assoiciated with the email in rows for the employess
pleae advise


"Ashish Mathur" wrote:

Hi,

Sort in ascending order on column B and then use Data Subtotal.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Dylan lotz" <Dylan lotz @discussions.microsoft.com wrote in message
...
if I have 500 rows and several col

and lets say col B is office cities

IE Dallas, Fort Worth, Austin, Houston

and the col F
has sales totals
Is there a way I can subtotal the col f in setter work sheet
IE
if col b = Dallas, subtotal everthing that = dallas by col F

if function
 

Hi,

Create a pivot table. Drag column B to the row area and column F to the
data area.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

" wrote in message
...
could you elaborate, Datasubtotal:

Please help

col b; has several city names, col c wiht emplyee names ect.

Then col F has the employess sales totals, we constanctly add employee
lines,
so it would be much easier to say if colb=dAllas sum all totals associated
w/ col F.

My staff is not good enough to this in a pivot tabel. dont know is If I
could inorporate this in a =stringconcat vba formula to consolidate email
address assoiciated with the email in rows for the employess
pleae advise


"Ashish Mathur" wrote:

Hi,

Sort in ascending order on column B and then use Data Subtotal.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Dylan lotz" <Dylan lotz @discussions.microsoft.com wrote in message
...
if I have 500 rows and several col

and lets say col B is office cities

IE Dallas, Fort Worth, Austin, Houston

and the col F
has sales totals
Is there a way I can subtotal the col f in setter work sheet
IE
if col b = Dallas, subtotal everthing that = dallas by col F