LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default sum alphanumeric cells

I am trying to sum alphanumeric cells, the following cells have:

A1= Mon, A2= blank
B1= Tue, B2= 3
C1= Wed, C2= 4a
D1=Thur, D2= blank
E1= Fri, E2= 3s
F1= Sat, F2= 1a
G1= Sun, G2= 2s
H1= Mon, H2= 4
i1= Tue, i2= 7s
J1=Wed, J2= blank
K1=Thur, K2= blank
L1=Fri, L2= 1
M1=Sat, M2= 8
N1=Sun, N2= blank
O1=Mon, O2= 6a

"a" represents Annual Leave, "s" represents Sick Leave, and a number
represents Over Time. The numbers, alphanumeric numbers, and blank
cells can randomly be in any day of the week cell/column. My goal is
to sum cells that have "a" and sum cells that have "s" and sum cells
that have a number seperately, example...

A4 = "Over Time"
A5 = "16" (3 + 4 + 1 + 8 = 16)
B4 = "Annual Leave"
B5 = "11" (4a + 1a + 6a = 11)
C4 = "Sick Leave"
C5 = "12" (3s + 2s + 7s = 12)

Can anyone please help me...?
Sincerely,
JimmyD

 
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
Count Cells with alphanumeric data Aris New Users to Excel 9 May 18th 23 07:42 PM
Calculate number between two alphanumeric cells Jennifer Medina[_2_] Excel Discussion (Misc queries) 5 December 4th 07 02:28 AM
extracting numbers from alphanumeric cells Mary Excel Worksheet Functions 6 February 22nd 07 12:04 PM
how to format alphanumeric cells as numbers jennifer72401 Excel Discussion (Misc queries) 1 February 9th 06 06:45 PM
alphanumeric cells Kristy Excel Worksheet Functions 1 November 8th 04 06:58 PM


All times are GMT +1. The time now is 08:09 PM.

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"