Forum Discussion

Excel's avatar
Excel
Iron Contributor
Aug 20, 2022
Solved

Query related to excel

Hello Everyone, 

 

I am looking to enhance my monthly budget and enter in my charges for the month and tag those payments as certain categories (groceries, movies, shopping, subscriptions, etc). Once tagged, I would like to sum the total of those categories and enter them into my monthly budget. The goal is moving forward to have a set of categories that can be assigned to data and have it automatically populate into my monthly budget based on the tag.

 

Please help ?

 

Here is a attached file

excel
Formulas and Functions
    • Excel's avatar
      Excel
      Iron Contributor
      Aug 29, 2022

      Riny_van_Eekelen 

       

      Hello Sir,

      i want to count how many TRUE or FALSE are there ?

      When i use COUNTIF function in F14, then it shows 0.

       

      Please help..

       

      Here is a attached file

      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Aug 29, 2022

        Excel Remove the quotation marks surrounding when using the words True and False. Then it will work.

        But, I changed your formulas a bit. Also those in H:I, as you don't need an IF function when you want to return either TRUE or FALSE. In stead of:

        =IF(F5>34000,"True","False")

        you can just use

        =F5>34000

         

         

Resources