Calculating catagory totals for a budget

[RadMan]

Hello,

I would like my spreadsheet to look for and total all Groceries and Gas & Fuel into 2 separate cells as i paste my banking transactions into a range of cells. Is it possible to automatically add all my Groceries and Gas & Fuel category's, respectively, using a function or Conditional format?


https://docs.google.com/open?id=12L03hY7nPRE-iiQVhyxArolNRWr8zxCTCMxcrowWmU5oKEz-H-fydyAsXRNb


Thanks

Mark

 

[SirJB7]

Hi, RadMan!


I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).

Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.

Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, well, come back here, tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.


And about your question...

CF doesn't separate cells or move/copy data, it just conditional formats existing data.

What you could do is use SUMIF function so as to group subtotals for each concept (i.e., =SUMIF(F:F,G2,D:D) formula). If you want to check for multiple conditions, check SUMIFS function (available it only in 2007/2010 Excel versions), otherwise you should use SUMPRODUCT function.


Regards!

 

[RadMan]

Thank you. I'll do a search on SUMIF function.

 

[SirJB7]

Hi, RadMan!

Glad I could help you. Thanks for your feedback and welcome back whenever needed or wanted. If you want to add date constraints and you can't figure it out then just advise.

Regards!