Need Help With Excel - Urgently

I have a huge Excel table and I need to count few things.

The table consists if multiple columns and I need to take into consideration Territory, Date, and Budget.

I need to count amount if budget ranges per month.
E.g. In January I had 10 budget ranges of $0 to $500, $500 to $1,500, and $5000+

The result should look like in January you have 10 of $0 to $500, 23 of $500 to $1,500, and 56 of $5000+

Then, ideally I also breakdown this by territory, separely.

How do I do that?

I partially found how to some of this with pivot tables but I have issues putting it all together and Excel is giving me errors.

Any Excel experts that can help?

ChatGPT-4 advanced data analysis mode can do this. Just give it the right prompt, explain your problem clearly.

randomUN said:

ChatGPT-4 advanced data analysis mode can do this. Just give it the right prompt, explain your problem clearly.

Click to expand...

I am using 3.5 it keeps telling me I have 49 records for Jan (based on my criteria) while if I do simple sorting I can clearly see it’s 72.

You need to use 4. It's comes with beta features, including advanced data analysis. You can give it the prompt and it will give you a .csv with your requirements.

randomUN said:

You need to use 4. It's comes with beta features, including advanced data analysis. You can give it the prompt and it will give you a .csv with your requirements.

Click to expand...

Thanks!

But there should be a way to do it jsut with excel.

Watch this then use COUNT (category)