| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for adding sums
I have multiple locations in column B ...B2:B1700 Site A, B, C, ...
In column N2:N1700 I have a number 0, 1, 2 3, 4 and so forth Column B = Site X Column N= 0 Column B = Site X Column N= 0 Column B = Site X Column N= 1 Column B = Site U Column N= 4 Column B = Site U Column N= 1 I need to add the totals of Site X that equal 0, and Site X that equal 1 etc.. Site X has 3 0's, and Site X has 6, 1's .... From this information I need to make a chart that shows the number per site -- CMB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding sums from different worksheets | Excel Worksheet Functions | |||
| Finding a value by adding certain sums in a range? | Excel Discussion (Misc queries) | |||
| adding multiple sums w/ different criteria | Excel Discussion (Misc queries) | |||
| Adding sums only in certain colored cells | Excel Worksheet Functions | |||
| Adding up Sums | Excel Worksheet Functions | |||
Threaded Mode
