Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default how can i format a cell with 3 diffrent group to add





in Excell Iam trying to make it add the number after 3 different groups.
Each cell I will input pa,pp,pn to be seperated on a lower cell but after
pa or pp or pn there will be a number to add like pn 1, pp2, pa5 .

on a lower cell below the inputs i will have 3 cells that will add up the
pa's , pp's, pn's .

Example on wednesday: pa used 2 hours ,pa also used 4 , pn used 7 , pp
used 3.2 hours and pn used 5 hours. On my end result on my botttom sheet on
this wednesday it will add all the pa's , pp's and pn's which should come
out to pa6, pp3.2 and pn 12.


hopefully its understandable and someone is able to assist me. I know there
is a format to give that cell a fuction to add 3 different groups

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
Format Issue DS Excel Worksheet Functions 4 October 13th 06 01:20 AM
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
Urgent date/scheduling calc needed jct Excel Worksheet Functions 3 February 24th 06 01:36 AM
Cell data format falloutx Excel Discussion (Misc queries) 1 February 10th 06 01:46 PM
Format of a cell profG Excel Discussion (Misc queries) 1 January 16th 06 03:02 PM


All times are GMT +1. The time now is 11:30 PM.

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

About Us

"It's about Microsoft Excel"