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). On...
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Aug 20, 2022

    Excel 

    On row 4 enter this:

    =SUMIF($I$4:$I$38,A4,$J$4:$J$38)

    and copy down.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Aug 20, 2022

Excel 

On row 4 enter this:

=SUMIF($I$4:$I$38,A4,$J$4:$J$38)

and copy down.

  • 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

       

       

      • Excel's avatar
        Excel
        Iron Contributor
        Aug 31, 2022

        Riny_van_Eekelen 

         

        Hello Sir,
        I have a table on which I want to apply certain conditional formatting based on which it will show me the cells in a certain color if the condition is true.

        In the below dataset, I want "Need to Check" to be highlighted in Red and "All Good" in Green. The dataset is dynamic i.e. the 'New Packet No' and 'Old Packet No' will change values from time to time.

        Please suggest how can I achieve the same.

         

        Here is a attached file...

Resources