Help

S

sheeks

New Member
Joined
Jul 5, 2011
Messages
6
Hi, I need help in the formula to be used. Im doing a spread sheet that has Job Complete (date) -A- column and task column -B-. When the job is completed I put in the date complete in Column A and the task for each job is already been specified. I need to find the total number of completed task ONLY. How do I do this?

<TABLE style="WIDTH: 100pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=133 border=0><COLGROUP><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523" width=69><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD class=xl65 id=td_post_2228124 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 52pt; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: white" width=69 height=21>Task</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent" width=64> Job Complete</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: white" height=21>8</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: windowtext; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: white" height=21>7</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: windowtext; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: white" height=21>12</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: windowtext; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: white" height=21>18</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: windowtext; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">3/13/2011</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: white" height=21>17</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: windowtext; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: white" height=21>3</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: windowtext; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: white" height=21>7</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: windowtext; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"> 3/24/2011</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: white" height=21>2</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: windowtext; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: white" height=21>5</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: windowtext; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: white" height=21>4</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: windowtext; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD></TR></TBODY></TABLE>

How do I find the total number of task that only has a completion date. This list goes on to hundreds so I cant just do manual calculation. Thanks.

Sheeks.
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Sort by date Sort by votes
That looks to me like the date is in column B, not A.

Try

=COUNT(B:B)
 
Upvote 0
Peter,

An error box appear. mentioning Excel cannot calculate.and mention something about circular reference. I need to find the sum of the tasks completed based on the completion. Thank you.
 
Upvote 0
That formula cannot go in column B. Try like this

Excel Workbook
ABC
1TaskJob CompleteCount
282
37
412
51813/03/2011
617
73
8724/03/2011
92
105
114
Sheet1
 
Upvote 0
I got it.... awesome. Thank you. BUT there's one more thing... I nedd to sum up the TASK with respect to the completed job ie the 18+7 ( A5 + A8) but not only the 2 dates... dates for the future as well... the date column will be filled up when a job is completed and tasks needed to be added up. Thanks Pete.
 
Upvote 0
Try like this


Excel Workbook
ABC
1TaskJob CompleteCount
282
37Sum
41225
51813/03/2011
617
73
8724/03/2011
92
105
114
Sheet1
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
617
smozgur
smozgur
T
  • Question Question
Exporting Cell Range As PNG - Getting A White Border To The Bottom & Right - Why?
2
Replies
16
Views
175
jolivanes
jolivanes
V
  • Solved
How to put a space in this table in VBA?
Replies
1
Views
501
VBAEXCELNew
V
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
E
  • Question Question
VBA code clean up
Replies
9
Views
573
mumps
mumps

Forum statistics

Threads
1,224,521
Messages
6,179,291
Members
452,902
Latest member
Knuddeluff

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