How to check if the total for a repeated value matches in every instance

Question

Hi,I have a list of IDs in one column, and their total books in another.&nbsp; The IDs are in the column multiple times.&nbsp; I am trying to find a way in excel to check if the total balance for one ID matches in every instance the ID is listed.Any ideas on how I can accomplish this?

riny_van_eekelen · Answer

Gdis_Lebron&nbsp;Look into the SUMIF function.Yo might find the link below useful.https://exceljet.net/excel-functions/excel-sumif-function&nbsp;

gdis_lebron · Answer

Thank you. This did not help me identify IDs whose values did not match.

riny_van_eekelen · Answer

Gdis_Lebron&nbsp;You're welcome. But perhaps you can clarify what you really need.&nbsp;

Forum Discussion

How to check if the total for a repeated value matches in every instance

Share

Resources