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

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
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

K
  • Question Question
Populate Remarks Based on Criteria
Replies
3
Views
79
Sergius
S
S
  • Question Question
Yearly Interest Calculation
Replies
1
Views
339
signup
S
M
  • Question Question
Drop down list with selection containing Alpha and Numeric characters not working
Replies
1
Views
126
myall_blues
myall_blues
N
  • Solved
Count days between to Table Ranges that falls in SLA intervals
Replies
4
Views
127
Nicha
N
P
  • Question Question
Analytics Project - Sumifs
Replies
1
Views
560
bobaol
B

Forum statistics

Threads
1,224,823
Messages
6,181,176
Members
453,021
Latest member
Justyna P

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