Good Afternoon (AEST),
I use excel (MS Office 365 built 1701 (build 7766:2060).
I have created a complex excel spreadsheet that list's all my paid invoice and does all my tax, net income and gross income.
However, I have some client's that are repeats.
I am wondering, if there is a way, I can take data from SHEET 1, my client's name cell(s) + gross income cell(s) and tally them into a singluar field?
EG: if I a client 1electricalguys and they appear 12 times and I have earned gross 7k out of them, can I have it tallied into 1 field/cell on SHEET 2 with client details + gross income?
This way, going forward I can see who my most loyal clients are.
Please let me know,
Thank you,
- Tech-Xcellent
Bookmarks