Hi,
I have a table of data that has 800+ entries. A lot of the entries have the same information in the first 3 columns but the fourth column (D), showing hours, has a different number than the last.
I need a formula to add up the hours if the data in the first 3 columns is exactly the same. If one of the column's data is different then it needs to remain as an independant entry.
If it would be possible to automatically show the formulated data like I have done in my example table then this would be a bonus!
Thanks,
Alex
Bookmarks