Payroll Consumption - How to validate this number.

To get a matching number to your consumption  report please pull your payroll history report 

Then  Copy Column  C to Sheet 2

1. Select Column C and copy data

2.  Create  new Sheet

3.   Paste   Data

4. Highlight data and then select remove duplicates 

5.  Click okay based on the exmaple below

6.You will see your total amount but you MUST remove the heading eg member name so my example would be 138 members.