LogFAQs > #879340817

LurkerFAQs, Active DB, Database 1 ( 03.09.2017-09.16.2017 ), DB2, DB3, DB4, DB5, DB6, DB7, DB8, DB9, DB10, DB11, DB12, Clear

Topic List	Page List: 1
Topic	Any mediocre excel users on here? Need some help with the sum function...
AngelsNAirwav3s 05/18/17 12:17:42 PM #4:	VGfreak96 posted... Use this formula: =SUM(A1:INDEX(A:A,B1+COLUMN(A1)-1)) Sums number of cells in column A according to what value is in B1. Amazing! If you have some time can you give me a quick rundown of how the index function works there to get the other half of the range? If not no worries --- Hello world! <cite>AngelsNAirwav3s posted [p:879340817] in Any medioc... [t:75359594]...</cite> <quote><cite>VGfreak96 posted...</cite> <quote>Use this formula: =SUM(A1:INDEX(A:A,B1+COLUMN(A1)-1)) Sums number of cells in column A according to what value is in B1.</quote> Amazing! If you have some time can you give me a quick rundown of how the index function works there to get the other half of the range? If not no worries --- Hello world!</quote> ... Copied to Clipboard!
Topic List	Page List: 1