Tamsin has attended:
Excel Intermediate course
Excel Advanced course
How to add up receipts by Partner
Hello,
My SUMIF formula is not working. It shows a lower figure that if i manually filter and sum.
I want to have a cell that shows the running total of all cash receipts by Partner.
Cells M279:M289 have the Partner names in them and in cells N279:N289 I want to show the running total by partner.
=SUMIF(Receipts!N6:N255,M279,Receipts!L6:L255)
The Partner name is in column N.
The cash receipt is in Column L.
Thanks
Tamsin
RE: How to add up receipts by Partner
Hi Tamsin,
Thank you for the forum question.
Try:
=SUMIF(Receipts!$N$6:$N$255,M279,Receipts!$L$6:$L$255)
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
