if function

[Dylan lotz]

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

 

[Fred Smith]

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

Regards,
Fred

 

[Ashish Mathur]

Hi,

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[dlotz]

could you elaborate, Data>subtotal:

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]

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