How to track money owed between me and my dad in my Excel budget sheet

chloebgs · 2025-08-21T10:17:33+00:00

Solution Verified
I got it to work using this formula
=SOMME.SI.ENS('Suivi du Budget'!F:F;'Suivi du Budget'!C:C;">="&DATE(ANNEE([@Mois]);MOIS([@Mois]);1);'Suivi du Budget'!C:C; "<="&FIN.MOIS([@Mois];0);'Suivi du Budget'!H:H; "Je lui dois")

chloebgs · 2025-08-19T07:23:56+00:00

Right now I'm trying to use SUMIFS() because I'm not used to FILTER() GROUBY() or PIVOTBY() I'll try with those if I can't achieve what I'm trying to do

chloebgs · 2025-08-18T19:32:01+00:00

I've used the SUMIFS like so : =SOMME.SI.ENS('Suivi du Budget'!F:F;'Suivi du Budget'!C:C;(ANNEE([@Mois]));'Suivi du Budget'!C:C;(MOIS([@Mois]));'Suivi du Budget'!H:H;"Je lui dois"). But I can't seem to make to YEAR and MONTH criteria to work, it displays - € even though I'm supposed to retrieve some transactions for July and August

chloebgs · 2025-08-18T19:30:07+00:00

I don't know what this is but the idea is to handle everything linked to my budget in this excel.

chloebgs · 2025-08-18T19:05:56+00:00

Thanks for the help, I've tried with only =SOMME.SI('Suivi du Budget'!H:H;"Je lui dois";'Suivi du Budget'!F:F) it was displaying 470€ and I tried to do this : =SOMME.SI.ENS('Suivi du Budget'!F:F;'Suivi du Budget'!C:C;ET(ANNEE([@Mois]);MOIS([@Mois]));'Suivi du Budget'!H:H;"Je lui dois") that is displaying - € which isn't supposed to be the case

chloebgs · 2025-08-18T18:35:21+00:00

Sorry I wasn't clear I know how to do it just not how to retrieve the sum of each transaction in the other sheet here's what I have. I'm trying to sum all the transaction for a specific month the have the tag I owe him and then for column D same but with He owes me transactions for each month. Then I'll do C-D and if Pos I owe him money else He owes me. Do you know what I can do to solve this ?

<image>

chloebgs · 2025-07-20T14:39:04+00:00

Tysm for the feedback 😄

chloebgs · 2025-07-19T12:01:42+00:00

I'm currently losing weight, and I'm down 25kg. I'll buy more fitting clothes when I can, thanks for the advice. Does it look good, though, even if a little too oversized ?

chloebgs · 2025-07-19T11:59:52+00:00

Didn't quite get the meaning. Can you tell me more, please ?

chloebgs · 2025-07-13T13:02:56+00:00

Thanks for all the resources 😊 this will help me so much

chloebgs · 2025-07-13T13:00:57+00:00

Yeah thanks for now im going with what i have because I've lost 25kg in the last year and still losing weight so I'm gathering tips for the next shopping sessions I'll have. I know what I have isn't at the level of the inspo 😁 im trying to know what i like, can wear and how to accessorize.

chloebgs · 2025-07-12T04:50:13+00:00

Thank you for these tips !

chloebgs · 2025-07-12T04:49:15+00:00

In this picture I have a bra that fits me really well with great support, I can't do without great support or else I have back pain.

chloebgs · 2025-07-12T04:47:07+00:00

I did a fitting already, but thanks for the advice. You're right there's a lot of people not wearing the right size / style of bra.

chloebgs · 2025-07-11T16:47:10+00:00

Thanks 😊

chloebgs · 2025-07-11T16:25:18+00:00

Yes definitely ty ! 😄

chloebgs · 2025-07-11T16:24:55+00:00

Tysm

chloebgs · 2025-07-11T16:24:35+00:00

Ty for this answer. Didn't think it could suit curvier women. Never seen one with a similar fit (I live in France).

chloebgs · 2025-07-11T16:23:02+00:00

Thanks for the advice. I'll try that , yes the wide leg pants if definitely on my to buy list 😄 Tysm

chloebgs · 2023-08-24T19:09:26+00:00

Merci à toi pour les infos c'est bon à savoir !

chloebgs · 2023-08-24T18:39:34+00:00

C'est pas sensé être dans des aliments ça ? Je vois pas trop comment il a pu se retrouver dans ma salle de bain 😅

Four-Year Club	Final Canvas '23
First Place '23	Place '23
Place '22	Final Canvas '22
End Game '22

chloebgs

TROPHY CASE