tally data from SHEET 1 to SHEET 2.

**techxcellent** · 03-14-2017, 01:04 AM

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

**FDibbins** · 03-14-2017, 01:19 AM

Hi, welcome to the forum

You probably need to look at the SUMIF() function for that. Play around and see how far you get. If you still have a problem, I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.