Forum Discussion

excel_learner's avatar
excel_learner
Brass Contributor
Nov 16, 2021
Solved

Formula drag down help

Hi,  I'm trying to see if there is a way I can drag down a formula but miss out certain cells.   So I have 3 separate rows for Forecast Budget and Actuals which all require different formulas of S...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Nov 16, 2021

    excel_learner 

    Something along these lines:

     

    =IFS($E5="Budget",SUMIFS('Budget Input'!$Q:$Q,'Budget Input'!$E:$E,$A5,'Budget Input'!$C:$C,$C5,'Budget Input'!$AJ:$AJ,$D5,'Budget Input'!$AU:$AU,F$2),$E5="Forecast",SUMIFS('Forecast Input'!$Q:$Q,'Forecast Input'!$E:$E,$A5,'Forecast Input'!$C:$C,$C5,'Forecast Input'!$AJ:$AJ,$D5,'Forecast Input'!$AU:$AU,F$2),$E5="Actual",SUMIFS('CMO Input'!$Q:$Q,'CMO Input'!$E:$E,$A5,'CMO Input'!$C:$C,$C5,'CMO Input'!$AJ:$AJ,$D5,'CMO Input'!$AU:$AU,F$2))

     

    Using the actual names of the other input sheets of course.

HansVogelaar's avatar
HansVogelaar
MVP
Nov 16, 2021

excel_learner 

Something along these lines:

 

=IFS($E5="Budget",SUMIFS('Budget Input'!$Q:$Q,'Budget Input'!$E:$E,$A5,'Budget Input'!$C:$C,$C5,'Budget Input'!$AJ:$AJ,$D5,'Budget Input'!$AU:$AU,F$2),$E5="Forecast",SUMIFS('Forecast Input'!$Q:$Q,'Forecast Input'!$E:$E,$A5,'Forecast Input'!$C:$C,$C5,'Forecast Input'!$AJ:$AJ,$D5,'Forecast Input'!$AU:$AU,F$2),$E5="Actual",SUMIFS('CMO Input'!$Q:$Q,'CMO Input'!$E:$E,$A5,'CMO Input'!$C:$C,$C5,'CMO Input'!$AJ:$AJ,$D5,'CMO Input'!$AU:$AU,F$2))

 

Using the actual names of the other input sheets of course.

Resources