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 58,937 as the budget for GL 57010104..

 

Help much appreciated

Formulas and Functions

13 Replies

  • 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?

Resources