| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Sum a column if reference column is blank
How do I sum a cloumn of numbers when my reference column is blank?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to Sum a column if reference column is blank
when my reference column is blank?
What does that mean? -- Mike When competing hypotheses are equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. Occam''''s razor (Abbrev) "Rusty" wrote: How do I sum a cloumn of numbers when my reference column is blank? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to Sum a column if reference column is blank
See if this is what you had in mind...
96...x 51..... 22...p 73..... 81..... Sum A1:A5 where the corresponding cell in B1:B5 is blank/empty: =SUMIF(B1:B5,"",A1:A5) Result = 205 (51+73+81) -- Biff Microsoft Excel MVP "Rusty" wrote in message ... How do I sum a cloumn of numbers when my reference column is blank? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Non-Blank Cells in Column If a Reference Criteria Met. | Excel Discussion (Misc queries) | |||
| How to reference last non-blank cell value from a column cells? | Excel Worksheet Functions | |||
| insert a blank column between each column in a data file | Excel Discussion (Misc queries) | |||
| Warning message if one column contains any text and another column is blank | Excel Worksheet Functions | |||
| COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN | Excel Worksheet Functions | |||
Hybrid Mode
