Forum Discussion

ACoffi1967's avatar
ACoffi1967
Copper Contributor
Jul 29, 2022

IfSum question

I have an Excel sheet with 12 columns and several rows of data.  I need to create a column of YTD information that will change depending upon the month.  What would my formula be if I change the # in...
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jul 29, 2022

ACoffi1967 In what would be P3 (if I counted correctly) enter this:

=SUM(C3:OFFSET(B3,0,$O$1))

 

  • ACoffi1967's avatar
    ACoffi1967
    Copper Contributor
    Jul 29, 2022
    Got it! Thanks.
  • ACoffi1967's avatar
    ACoffi1967
    Copper Contributor
    Jul 29, 2022
    Revenue is Row 3, Description is Column A = so revenue is A3
    For each month then Revenue would be B3, C3, etc.
    The # that changes o return the sum is Current month - in example 4 in Cell N1
    So if N1 is 4 the total should be sum of B2:E2
    If N1 changes to 3 the total should be sume of B2:D2

Resources