How do I sum a cloumn of numbers when my reference column is blank?
M Mike H Jan 15, 2010 #2 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)
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)
T T. Valko Jan 15, 2010 #3 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)
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)
