98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » How to add up receipts by Partner
How to add up receipts by Partner
Resolved · Medium Priority · Version 365
Fri 13 Mar 2020, 12:03Delegate Tamsin said...
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
Sat 14 Mar 2020, 11:47Trainer Jens said...
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
Sat 21 Mar 2020: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Activating the formula bar with the keyboard in Excel 2010The formula bar in Excel 2010 contains a number of different formulas. However, it is time consuming to open the formula bar every time and insert the formula using the mouse. Instead, you can activate the formula bar with the keyboard. Simply press the F2 button on the keyboard then the information in the cell will expand allowing you to edit the information in the cell. |
