Query related to excel

[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

[#2 · Accepted solution]

@Excel 

On row 4 enter this:

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

and copy down.

[#3]

@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

[#4]

@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

[#5]

Thank you very much sir.

[#6]

@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...

[#7]

@Excel You can select Column F. Then on the Home ribbon select Conditional Formatting, Highlight Cells Rules, Equal To... and set the relevant wording and choose the format. Repeat for each of the criteria.

For the future, may I suggest that you open a new thread for each new question, unless when it is related to the existing tread. Now we have three unrelated issues, all in on thread.