Sumifs Labeling

I am not sure if this can be done nor where to start, need help with taking the formula below an once it finds the things that tie to zero label them in groups
So if it is 1 to many it will label that group with a "1" and then next maybe one to one and it labels it "2" . Basically i want to see the grouping of the things that are zero beside seeing it only as all 1 lump sum. Any ideas how to do this. The attachment has the items group by Colors. I just need it group by a Number or Letter or anything beside color.

=IF(ROUND(SUMIFS([Amount],[OPERATION/NAME],[@[OPERATION/NAME]]),2)=0,"Zero")

Would it help if i did not run the formula off the [Amount] and have it state to look at the [payment] sumif the value of the number 251.01 for example with the numbers in [Receipts] and then label them as a group. etc etc. Would that work?

Ok, now i understand. Let me know what you find. FYI the original data sheets is like 5k Lines,setup the exact same way.If you are setting up a vba could you include to extraction of all the group data to tab or a new worksheet. New worksheet would be preferred

Also as a FYI that you probably already know in the original data Column1 aka H. Is not there.

Grouping by Operation/Name or Column C. Because the title can change and per the attachment is example. Notice Tab Sheet 2 for the extraction of data that would normally be in a different Workbook as Sheet 1. Is this what you were referring to?

=IF(ROUND(SUMIFS([Amount],[OPERATION/NAME],[@[OPERATION/NAME]]),2)=0,"Zero")

Continue to test but so far it is working. Question. I notice column H needs to be present having the formula already ran. Is it possible to include that logic in the beginnging of the vba for that formula. I actually insert column H, Apply the formula to all lines with the formula below. If that is to much for the system to handle i can run this into two forms. Or can i run two vba. Can you help me with that as well. Attached is an example of the original Data.


=IF(ROUND(SUMIFS([Amount],[OPERATION/NAME],[@[OPERATION/NAME]]),2)=0,"Zero")

Totally understandable

Will this logic or process work better in Access

Need help adding the below formula in the beginning of this vba and Appling the formula to all lines. Then taking that Grouped data of Zero by [Operation /Name ] and creating a tab for each, labeling the tab by their [operation name] and then run the Full vba that i have attached to each tab that will have a running number that is not used twice in the file so i can have a summary tab of all Grouped number in its separate tab with data.

=IF(ROUND(SUMIFS([Amount],[OPERATION/NAME],[@[OPERATION/NAME]]),2)=0,"Zero")

I apologize this came thru twice. I couldnt find my orginal email.

Sourabh

How are you? Need your help once more with the Example Data1.xlsm spreadsheet. Is there a way to adjust the Macro to Label per Column A. Meaning if the number in Column A is the same, sum all and label and the entire group per A and then go to the next and do the same. I will drop data into this spreadsheet in order by Column A. For this file all that is need is a label by column A that sum to zeros.I have attached and example of what it would look like. Also could have the collumen H be moved to AB of AC for the search as welll.