Hello,
I originally got some help for my issue and came up with this formula:
=IF(AB11=AB10,"",SUMIF(AB:AB,AB10,AC:AC))
The reason for this is to have excel realize when Company1 ends and to total the value, then continue on for reach company. The actual sheet is over 20,000 rows.
On the test sheet this formula works because I have company names listed as Company1, Company2, ect.. to keep names private. However, this formula no longer works when dealing with the actual company names on the real file.
Is there anyway to adjust this, so it will work with real company names and return correct values? Test Sheet is attached, feel free to use random names if needed.
Bookmarks