Forum Discussion

Rhys Smith's avatar
Rhys Smith
Copper Contributor
Mar 25, 2018

Need some help regarding a workable formula

Hi all,   I am looking to see if anybody would be able to help make a workable formula for my budget I am making for myself.   I have attached two images - hopefully this makes sense? Basi...
Formulas & Functions
Requests
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Mar 25, 2018

Rhys,

 

are you sure you are in the right community? The screenshots don't look like Excel.

 

  • Rhys Smith's avatar
    Rhys Smith
    Copper Contributor
    Mar 25, 2018

    Hi Detlef,

     

    Thanks for the response - the version I use for Excel would probably be classed as 'ancient' these days, it is around the 2010 version...
    I was hoping although it is an older version of Excel the formulas would still be very similar?

    Regards
    Rhys

    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Mar 25, 2018

      Rhys,

       

      I just noticed the tag "Excel on Mac". That's why it looks so different.

       

      I would recommend a pivot table. Simple and efficient.