Hi everyone
I'm creating an expense spreadsheet but want to total each type of purchase, be it food, health, misc, etc. I managed something like this years ago but cannot remember how to do it (old age (isn't) golden). I have attached a simplified example.
Thanks in advance.
Paul
Example.xlsx
Still using Excel 2021? Did you try SUMIF?
=SUMIF($C$2:$C$17,J3,$G$2:$G$17)
I am enjoying my golden age - learning more than ever.
Last edited by AliGW; 02-02-2025 at 05:03 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hi AliGW
No it's not Excel 2021 but Sheets on a Chromebook. Hate it but benefits don't allow for better at the moment.
Paul
Thank AliGW that works a treat.
OK - so please update your profile with what you are using (how else are we to know?) and please post your questions in the Other Platforms section. I am moving this thread. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks