Solved

# is there a better formula

Posted on 2015-01-23

the below formula is in a spreadsheet I am working on. Is there a better and shorter way to say this

=IF(MonthlyQuarterly!$S$1=MonthlyQuarterly!AF$3

SUM(MonthlyQuarterly!AF$4:AF$32)

IF(MonthlyQuarterly!$S$1=MonthlyQuarterly!AG$3

SUM(MonthlyQuarterly!AG$4:AG$32)

IF(MonthlyQuarterly!$S$1=MonthlyQuarterly!AH$3

SUM(MonthlyQuarterly!AH$4:AH$32)

IF(MonthlyQuarterly!$S$1=MonthlyQuarterly!AI$3

SUM(MonthlyQuarterly!AI$4:AI$32)

IF(MonthlyQuarterly!$S$1=MonthlyQuarterly!AJ$3

SUM(MonthlyQuarterly!AJ$4:AJ$32)

IF(MonthlyQuarterly!$S$1=MonthlyQuarterly!AK$3

SUM(MonthlyQuarterly!AK$4:AK$32)

IF(MonthlyQuarterly!$S$1=MonthlyQuarterly!AL$3

SUM(MonthlyQuarterly!AL$4:AL$32)

IF(MonthlyQuarterly!$S$1=MonthlyQuarterly!AM$3

SUM(MonthlyQuarterly!AM$4:AM$32)

IF(MonthlyQuarterly!$S$1=MonthlyQuarterly!AN$3

SUM(MonthlyQuarterly!AN$4:AN$32)

IF(MonthlyQuarterly!$S$1=MonthlyQuarterly!AO$3

SUM(MonthlyQuarterly!AO$4:AO$32)

IF(MonthlyQuarterly!$S$1=MonthlyQuarterly!AP$3

SUM(MonthlyQuarterly!AP$4:AP$32)

IF(MonthlyQuarterly!$S$1=MonthlyQuarterly!AQ$3

SUM(MonthlyQuarterly!AQ$4:AQ$32)

0))))))))))))