| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two totals in one cell shown in two separate columns
Hi,
I assume your information is from column A to L change it to fit your needs in column M enter =SUMPRODUCT(--(A8:L8="A"),A9:L9) in column O enter =SUMPRODUCT(--(A8:L8="S"),A9:L9) if this helps please click yes, thanks "something68" wrote: Column A, row 8 shows: A, S Column A, row 9 show: 1.0, 7.0 I would like Column M, row 9 to show: 1 (total of all "A" shown in row 8) I would like Column O, row 9 to show: 7 (total of all "S" shown in row 8) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine month day and year from separate columns in to one cell | Excel Discussion (Misc queries) | |||
| Summing cell totals across columns | Excel Worksheet Functions | |||
| I wish to separate city, state, and zip into 3 separate columns | Excel Worksheet Functions | |||
| Separate cell text FirstnameLastname into two columns | Excel Discussion (Misc queries) | |||
| Separate cell text FirstnameLastname into two columns | Excel Discussion (Misc queries) | |||
Threaded Mode
