Claus,
I appreciate your patience.
I have a resource tracking sheet that summarizes the resources per week and highlights any over allocations. Generally I don't need to know the specific resources for each department but I do want to know that information for my weld department. I designate welding resources by putting a number before the 'W' (#W). I have not been able to sum the numbers in front of the W. I thought I'd try using the comments for the number of welders required so then I could sum the comments. I don't really care how I do it but I would like to figure it out.
I have attached the results I desire.
You will see that I have a formula in all the rows except the 'W' row that works to add the letters in the columns. Any other suggestions would be welcome. I have tried MS Project and several other software programs and they just don't summarize all of my data like I need them to. So, Here we are. Thanks in advance. Phil
Quote:
Originally Posted by Claus Busch
Hi Phillip,
Am Thu, 22 Sep 2016 16:29:29 +0100 schrieb phillip cole:
I copied and pasted that to a module in my spreadsheet. then i set the
"sum" cell at the bottom of each column to e.g. "=ComSum(AE720:AE722)".
I selected the whole data table and named the range "myRng". It is
definitely getting me moving in the right direction but i'm getting some
funny results. sometimes its adding the comments with "M". Sometime
its adding up all the letters in the cells with comments but putting it
in as "MM" versus "2". Sometimes it's not returning a sum if i have
letters in the cell "AT" and a comment of "M".
i have attached the results and some other information.
what exactly do you want to do?
Do you want to sum the cell values with comment text "M"? OF do you want
to count the the comments with text "M"?
Please provide an example workbook with the expectd results in it.
Regards
Claus B.
--
Windows10
Office 2016
|
Similar Threads
Threaded Mode
