| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using the subtotals (data) can you use muliple functions(sum,max)
I want to use sum in one column and max in a different column
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using the subtotals (data) can you use muliple functions(sum,max)
hi Cooleys
subtotal has: =subtotal(N,range) N could be 1 - average 2 - count 3 - counta 4 - Max 5 - Min 6 - Product 7 - STDEV 8 - STDEVP 9 - Sum 10 - VAR 11 - VARP hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "cooleys" escreveu: I want to use sum in one column and max in a different column |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| Data Subtotals (similar but not exactly the same data) | Excel Discussion (Misc queries) | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
Linear Mode
