View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cware cware is offline
external usenet poster
 
Posts: 29
Default Sum of cells based on entry of adjacent cell

THANKS, but after I posted, I forwarded through and found an answer.

"cware" wrote:

I'm trying to have a summ of cells within a column, where the adjacent cell
has a specific alpha value.

800.64 R
7049.75 N
3345.6
-168
-33291 NR
481.25
-52.95
-162.12
-13.65
210
-2674.95 NI
-1
30
-54.54
4202.45 A
0
0
15.75
-381.75
702.75 E
-0.09
-413.85
-4034.1 T
-258.66


Above is what the two column look like. Off to the side, I would like to
summ all with E or all with T in separate cells for comparisons to take
place.

Does anybodyt know how to do this????