Forum Discussion
CountA as of
Hi Team, Need a help for this, I have a columns called "Assigned" and "Completed". They both are getting updated multiple time each day as new assigned and completed. When I create report for each...
Hi Valavan,
It looks like you have merged cells in very left column with date in unclear format ("Date as of <date>"). At the same time you'd like to have summary table for above dates. Not obvious task.
Perhaps it's easier to calculate the summary directly in you main list, e.g. using SUBTOTAL on count
=SUBTOTAL(2,$C$5:C27) =C28-SUBTOTAL(3,$D$5:D27)
If collect the same result in separate table we shall identify each record in above list or at least subtotals. If against each subtotal it will be the date we may return result as
=INDEX(D:D,MATCH(H7,B:B,1)) & " (to be completed) /" & INDEX(C:C,MATCH(H7,B:B,1)) & " (total assigned as of " & TEXT(LARGE(B:B,1),"yyyy-mm-dd") & ")"
Please see attached