Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Formula
Let's say column A is my project start date and column B is my project finish
date. I have my formula which calculates how many days it took me to complete each project which ranges anywhere from 1 day to 7 days. I had 20 projects last month and my contract is to complete each project within 3 days. I need excel to calculate how many projects were completed within 3 days and the total percentage. Any help is greatly appreciated! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Formula
James A. wrote:
Let's say column A is my project start date and column B is my project finish date. I have my formula which calculates how many days it took me to complete each project which ranges anywhere from 1 day to 7 days. I had 20 projects last month and my contract is to complete each project within 3 days. I need excel to calculate how many projects were completed within 3 days and the total percentage. Any help is greatly appreciated! =COUNTIF(A1:A20,"<4")/COUNT(A1:A20) and format the result as a percent. this assumes you have 20 entries for projects in A1:A20 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Formula
Try
=SUMPRODUCT(--(B1:B20-A1:A20<4))/COUNT(B1:B20) "James A." wrote: Let's say column A is my project start date and column B is my project finish date. I have my formula which calculates how many days it took me to complete each project which ranges anywhere from 1 day to 7 days. I had 20 projects last month and my contract is to complete each project within 3 days. I need excel to calculate how many projects were completed within 3 days and the total percentage. Any help is greatly appreciated! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Formula
PERFECT!!! Thanks Rowland. I appreciate your help.
"Rowland" wrote: James A. wrote: Let's say column A is my project start date and column B is my project finish date. I have my formula which calculates how many days it took me to complete each project which ranges anywhere from 1 day to 7 days. I had 20 projects last month and my contract is to complete each project within 3 days. I need excel to calculate how many projects were completed within 3 days and the total percentage. Any help is greatly appreciated! =COUNTIF(A1:A20,"<4")/COUNT(A1:A20) and format the result as a percent. this assumes you have 20 entries for projects in A1:A20 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Formula
Thanks for your help!
"daddylonglegs" wrote: Try =SUMPRODUCT(--(B1:B20-A1:A20<4))/COUNT(B1:B20) "James A." wrote: Let's say column A is my project start date and column B is my project finish date. I have my formula which calculates how many days it took me to complete each project which ranges anywhere from 1 day to 7 days. I had 20 projects last month and my contract is to complete each project within 3 days. I need excel to calculate how many projects were completed within 3 days and the total percentage. Any help is greatly appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |