Forum Discussion

arumel's avatar
arumel
Copper Contributor
Sep 06, 2020
Solved

SUMIF for first values only

Hello all,    Would like some help pls ..   I have a spreadsheet setup as follows:   In column E i would like to show the budget once for each GL per month .. so in Jan i only want to see...
Formulas and Functions
Wyn Hopkins's avatar
Wyn Hopkins
MVP
Sep 06, 2020
In cell E9 you could try =IF( AND( A9=A8, B9=B8), D8, 0 ) then copy that formula to the other cells in that column
  • arumel's avatar
    arumel
    Copper Contributor
    Sep 06, 2020

    Thanks Wyn Hopkins , but it doesn't seem to work .. maybe i am explaining it wrong ..

     

    attached is my file with periods Jan -Dec - within each period i have duplicate GL account lines - in the actual column i want to show for each month the budget value for the GL only once ..

     

    Thanks for your time

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Sep 06, 2020

      arumel 

      Sorry, your sample confuses. You say budget for each account shall be shown once per month.

      In the sample for the accounts which are not duplicates you show nothing, for repeating budget you ignore only first record and keep all the rest. Which exactly result do you expect?

      • arumel's avatar
        arumel
        Copper Contributor
        Sep 06, 2020

        Hello SergeiBaklan  .. the above pic is the result from the formula suggested by Wyn Hopkins  ..(which does not quite work out)

         

        I need column E to show only the first value of the budget for that GL (for that month) .. i.e GL 57010107 on row 12 should show 8,333 in column E ....  E14 and E15 should show zero as the GL is a duplicate for Jan .. similarly costs relating to Feb should show 8,333 in E76 and zero values for E77 and E78 ..

         

        Hope this clarifies

         

        Thanks for your time

Resources