hoshino,
See the attached workbook "Automating repetitive tasks - hoshino.xls".
The formula in cell H2 (copied down):
=SUMPRODUCT(($B$2:$B$1000=$G2)*($F$2:$F$1000))
You will not have to sort your data in column B.
If you would like this automated, then please post your workbook (and I will create a macro for you) - scroll down and see "Manage Attachments".
Have a great day,
Stan
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
Stanley
Thank you so much for the answer, that is an intellegent way to do it.
I can't upload the real workbook for priivacy reasons but have attached an example close to what I am working with....
If its possible to make a Macro for this I'd be most appreciative,
Thank you!
Hi
If columns C:E aren't really blank in your data, but have headings etc, then try using a pivot table to generate the list of unique names and sum the amounts.
rylo
Hi
Here is a macro which sums col F of each worker and lists it in col H & I
ravi
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks