Hi,
I need a formula help to split and sum a values based on values contains in a column A, In column A values is combined as month and Equipment and the Hours, it shall need to split and Summarize as in a Summary-1 (Column C to E) as like Month & Equipment & and Hours. As well in Summary-2 (Column G to H) based on values of Column A required to return an Total Equipment List and its Total worked Sum values.
Sample sheet are attached,
Thanks for the help,
Bookmarks