Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 48
Default how Sum if left (3 digits) are the equal to a field?

it is a pivot table, but I want to add two columns for total by row based in
the first three digits.

Pivot Table
I want to add.
Date STP-42 STP-45 STP-50 ACD-10 ACD-50 STP-total
ACD-total
9/20 1 2 1 2 2
3 4
9/21 1 2 1 2 2
3 4
9/22 1 2 1 2 2
3 4 9/23 1 2 1
2 2 3 4




please help.

Thanks
Ld

--
Lorenzo DÃ*az
Cad Technician
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If number in cell does not equal 6 digits, add zeros to the left kza40381 Excel Discussion (Misc queries) 2 July 9th 08 05:13 PM
Delete 4 to 5 digits from left in a cell Bob Phillips Excel Discussion (Misc queries) 2 April 27th 06 08:19 PM
Delete 4 to 5 digits from left in a cell Peo Sjoblom Excel Discussion (Misc queries) 3 April 27th 06 08:10 PM
Delete 4 to 5 digits from left in a cell Toppers Excel Discussion (Misc queries) 0 April 27th 06 07:33 PM
removing everything from the left after 10 digits tri_p Excel Worksheet Functions 3 September 30th 05 12:33 PM


All times are GMT +1. The time now is 09:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"