Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of cells based on entry of adjacent cell
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???? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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???? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of cells based on entry of adjacent cell
Try these:
=SUMIF(B1:B24,"E",A1:A24) =SUMIF(B1:B24,"T",A1:A24) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "cware" wrote in message ... 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???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum cells based on contents of adjacent cell (validated list)? | Excel Worksheet Functions | |||
Conditional coloring of Excel cells, based on adjacent cell values? | Excel Worksheet Functions | |||
Apply cell shading based on adjacent cells in EXCEL | Excel Worksheet Functions | |||
How do I set up Auotomatic date and time entry in an adjacent cell | Excel Discussion (Misc queries) | |||
I want to format a cell based on an adjacent cells value | Excel Discussion (Misc queries) |