reporting in excel

G

gerson02

New Member
Joined
Sep 9, 2018
Messages
10
Hi,
i need to have a report, i already done a little, but still need a help.

Code: 
[TABLE="width: 951"]
<tbody>[TR]
[TD]START DATE[/TD]
[TD]Get the Start Date based on the Task ID[/TD]
[/TR]
[TR]
[TD]WORK DAYS[/TD]
[TD]Get age of item in business days upon completion[/TD]
[/TR]
[TR]
[TD]SLA[/TD]
[TD]If item is completed within SLA, put 1, otherwise put 0 (refer to the Function SLA table for reference)[/TD]
[/TR]
[TR]
[TD]DAILY[/TD]
[TD]If item is completed on 4/11, put 1, otherwise 0[/TD]
[/TR]
[TR]
[TD]WEEKLY[/TD]
[TD]If item is completed from 4-5 to 4/11, put 1, otherwise 0[/TD]
[/TR]
[TR]
[TD]MONTHLY[/TD]
[TD]If item is completed from 4-1 to 4/30, put 1, otherwise 0[/TD]
[/TR]
[TR]
[TD]Completed Accounts within SLA (4/11/2018)[/TD]
[TD]Get total items completed for 4/11 that's within SLA[/TD]
[/TR]
[TR]
[TD]Completed Accounts outside SLA (4/11/2018)[/TD]
[TD]Get total items completed for 4/11 that's outside SLA[/TD]
[/TR]
[TR]
[TD]Total Completed Accounts (4/11/2018)[/TD]
[TD]Get total items completed for 4/11[/TD]
[/TR]
[TR]
[TD]SLA % (4/11/2018)[/TD]
[TD]Percentage of loans completed within SLA out of total loans completed for 4/11[/TD]
[/TR]
[TR]
[TD]Completed Accounts within SLA (4/5/2018 to 4/11/2018)[/TD]
[TD]Get total items completed from 4/5 to 4/11 that's within SLA[/TD]
[/TR]
[TR]
[TD]Completed Accounts outside SLA (4/5/2018 to 4/11/2018)[/TD]
[TD]Get total items completed from 4/5 to 4/11that's outside SLA[/TD]
[/TR]
[TR]
[TD]Total Completed Account (4/5/2018 to 4/11/2018)[/TD]
[TD]Get total items completed from 4/5 to 4/11[/TD]
[/TR]
[TR]
[TD]SLA % (4/5/2018 to 4/11/2018)[/TD]
[TD]Percentage of loans completed within SLA out of total loans completed from 4/5 to 4/11[/TD]
[/TR]
[TR]
[TD]Completed Accounts within SLA (4/1/2018 to 4/30/2018)[/TD]
[TD]Get total items completed from 4/1 to 4/30 that's within SLA[/TD]
[/TR]
[TR]
[TD]Completed Accounts outside SLA (4/1/2018 to 4/30/2018)[/TD]
[TD]Get total items completed from 4/1 to 4/30 that's outside SLA[/TD]
[/TR]
[TR]
[TD]Total Completed Account (4/1/2018 to 4/30/2018)[/TD]
[TD]Get total items completed from 4/1 to 4/30[/TD]
[/TR]
[TR]
[TD]SLA % (4/1/2018 to 4/30/2018)[/TD]
[TD]Percentage of loans completed within SLA out of total loans completed from 4/1 to 4/30[/TD]
[/TR]
[TR]
[TD]Remaining Account[/TD]
[TD]Get total number of items that are no yet completed[/TD]
[/TR]
[TR]
[TD]Conditional Fomating from D6 to F6[/TD]
[/TR]
</tbody>[/TABLE]


here is the table

Code: 
[TABLE="width: 1012"]
<tbody>[TR]
[TD="colspan: 2"]KPI[/TD]
[TD]4/11/2018[/TD]
[TD]4/5/2018 to 4/11/2018[/TD]
[TD]4/1/2018 to 4/30/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Completed Accounts within SLA[/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Completed Accounts outside SLA[/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Total Completed Account[/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]SLA %[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Remaining Account[/TD]
[TD="colspan: 3"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]FUNCTION[/TD]
[TD="colspan: 3"]GOAL in BUSINESS DAYS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]FX A[/TD]
[TD="colspan: 3"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]FX B[/TD]
[TD="colspan: 3"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]SLA% GOAL[/TD]
[TD="colspan: 3"]98%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]START DATE[/TD]
[TD]FUNCTION[/TD]
[TD]STATUS[/TD]
[TD]COMPLETE DATE[/TD]
[TD]WORK DAYS[/TD]
[TD]SLA[/TD]
[TD]DAILY[/TD]
[TD]WEEKLY[/TD]
[TD]MONTHLY[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/2/2018[/TD]
[TD]FX B[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/4/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/2/2018[/TD]
[TD]FX B[/TD]
[TD]On Hold[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/2/2018[/TD]
[TD]FX A[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/3/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/2/2018[/TD]
[TD]FX B[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/6/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/3/2018[/TD]
[TD]FX A[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/6/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/4/2018[/TD]
[TD]FX B[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/9/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/4/2018[/TD]
[TD]FX B[/TD]
[TD]On Hold[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/4/2018[/TD]
[TD]FX A[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/9/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/5/2018[/TD]
[TD]FX B[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/5/2018[/TD]
[TD]FX A[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/5/2018[/TD]
[TD]FX A[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/9/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/5/2018[/TD]
[TD]FX A[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/6/2018[/TD]
[TD]FX B[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/6/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/6/2018[/TD]
[TD]FX A[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/9/2018[/TD]
[TD]FX B[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/9/2018[/TD]
[TD]FX A[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/9/2018[/TD]
[TD]FX A[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/9/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/10/2018[/TD]
[TD]FX A[/TD]
[TD]On Hold[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/10/2018[/TD]
[TD]FX B[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/11/2018[/TD]
[TD]FX A[/TD]
[TD]Unassigned[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

i would really appreciate the answers thank you,
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Sort by date Sort by votes
Hi Gerson,
what is the excel related question you have? Do you have a hard time calculating something or missing a formula to calculate your KPIs? Right now your question reads like "please build me this report", for which you should hire someone, this forum we can help you building it.
Cheers,
Koen
 
Upvote 0
sorry for my previous post, actually KPI is my problem now, i really dont know how to get the SLA's because it have a dates.


Code: 
[TABLE="width: 1012"]
<tbody>[TR]
[TD="colspan: 2"]KPI
[/TD]
[TD]4/11/2018[/TD]
[TD]4/5/2018 to 4/11/2018[/TD]
[TD]4/1/2018 to 4/30/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Completed Accounts within SLA[/TD]
[TD="align: right"]????????
[/TD]
[TD]    ????????
[/TD]
[TD]    ????????
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Completed Accounts outside SLA[/TD]
[TD="align: right"]    ????????
[/TD]
[TD]    ????????
[/TD]
[TD]    ????????
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Total Completed Account[/TD]
[TD="align: right"]    ????????
[/TD]
[TD]    ????????
[/TD]
[TD]    ????????[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]SLA %
[/TD]
[TD]    ????????
[/TD]
[TD]    ????????
[/TD]
[TD]    ????????
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Remaining Account[/TD]
[TD="colspan: 3"]        ????????????????????????????????????????????????
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]FUNCTION
[/TD]
[TD="colspan: 3"]GOAL in BUSINESS DAYS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]FX A[/TD]
[TD="colspan: 3"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]FX B[/TD]
[TD="colspan: 3"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]SLA% GOAL[/TD]
[TD="colspan: 3"]98%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]START DATE[/TD]
[TD]FUNCTION[/TD]
[TD]STATUS[/TD]
[TD]COMPLETE DATE[/TD]
[TD]WORK DAYS[/TD]
[TD]SLA[/TD]
[TD]DAILY
[/TD]
[TD]WEEKLY
[/TD]
[TD]MONTHLY[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/2/2018[/TD]
[TD]FX B
[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/4/2018[/TD]
[TD]=IF(G21="","",DATEDIF(D21,G21,"d"))
[/TD]
[TD]=IF(H21<=D13,"1",0)
[/TD]
[TD]=IF(G21=43201,"1","0")
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/2/2018[/TD]
[TD]FX B[/TD]
[TD]On Hold[/TD]
[TD][/TD]
[TD]=IF(G22="","",DATEDIF(D22,G22,"d"))
[/TD]
[TD]same as above
[/TD]
[TD]same as above
[/TD]
[TD]=IF(AND(D21>=43195,G21=43201),"1","0")
[/TD]
[TD]=--(EOMONTH(D21,0)=EOMONTH(G21,0))
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/2/2018
[/TD]
[TD]FX A[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/3/2018[/TD]
[TD]=IF(G23="","",DATEDIF(D23,G23,"d"))
[/TD]
[TD]same as above
[/TD]
[TD]same as above
[/TD]
[TD]same as above
[/TD]
[TD]same as above
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/2/2018[/TD]
[TD]FX B[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/6/2018[/TD]
[TD]same as above, but depends on funtion
[/TD]
[TD]same as above
[/TD]
[TD]same as above
[/TD]
[TD]same as above
[/TD]
[TD]same as above
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/3/2018[/TD]
[TD]FX A[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/6/2018[/TD]
[TD]same as above, but depends on funtion
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/4/2018[/TD]
[TD]FX B[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/9/2018[/TD]
[TD]same as above, but depends on funtion
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/4/2018[/TD]
[TD]FX B[/TD]
[TD]On Hold[/TD]
[TD][/TD]
[TD]same as above, but depends on funtion
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/4/2018[/TD]
[TD]FX A[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/9/2018[/TD]
[TD]same as above, but depends on funtion
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/5/2018[/TD]
[TD]FX B[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD]same as above, but depends on funtion
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/5/2018[/TD]
[TD]FX A[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD]same as above, but depends on funtion
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/5/2018[/TD]
[TD]FX A[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/9/2018[/TD]
[TD]same as above, but depends on funtion
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/5/2018[/TD]
[TD]FX A[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD]same as above, but depends on funtion
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/6/2018[/TD]
[TD]FX B[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/6/2018[/TD]
[TD]same as above, but depends on funtion
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/6/2018[/TD]
[TD]FX A[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD]same as above, but depends on funtion
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/9/2018[/TD]
[TD]FX B[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD]same as above, but depends on funtion
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/9/2018[/TD]
[TD]FX A[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD]same as above, but depends on funtion
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/9/2018[/TD]
[TD]FX A[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/9/2018[/TD]
[TD]same as above, but depends on funtion
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/10/2018[/TD]
[TD]FX A[/TD]
[TD]On Hold[/TD]
[TD][/TD]
[TD]same as above, but depends on funtion
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/10/2018[/TD]
[TD]FX B
[/TD]
[TD]Completed[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD]same as above, but depends on funtion
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4/11/2018[/TD]
[TD]FX A[/TD]
[TD]Unassigned[/TD]
[TD][/TD]
[TD]same as above, but depends on funtion
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

sorry again
 
Upvote 0
Hi Gerson,
try the COUNTIFS function, that should probably do the trick, see a small tutorial here: https://exceljet.net/excel-functions/excel-countifs-function
The simplest is the Total Completed Account:
=COUNTIFS(G21:G50, 4/11/2018, F21:F50, "Completed") -> that should give you the total amount of lines with that complete date and status Completed. COUNTIFS can also be used with "date greater than" and "date before".
Hope that gets you started,
Koen
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
Yearly Interest Calculation
Replies
1
Views
289
signup
S
P
  • Question
Analytics Project - Sumifs
Replies
1
Views
484
bobaol
B
L
  • Question
INDEX MATCH
Replies
1
Views
309
Fluff
Fluff
H
  • Question
Macro to download zip, unpack and copy data
Replies
0
Views
597
HeinrichPaul
H
S
  • Question
Formatting Midnight in a date to 24 instead of 0:00
Replies
4
Views
505
shepcs
S

Forum statistics

Threads
1,221,813
Messages
6,162,117
Members
451,743
Latest member
matt3388

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top