About us - Contact us

DeskDemon
DeskDemon UK Click here for DeskDemon UK 
 Browse Forum Recent Topics  
 

Welcome to the DeskDemon Forums
You will need to Login in or Register to post a message. To start viewing messages, select the forum that you want to visit from the selection below.

Pages: [1]   Go Down
  Print  
Author Topic: Excel SUM / COUNT Formula  (Read 152 times)
SunnieG
Newbie
*
Posts: 28



View Profile
« on: July 09, 2014, 02:36:43 pm »

Can anyone help?  I've been looking at this for far too long now.

As an example, I am trying to count the number of times in a month a task is not 100% complete. 

Date                   Month   Task   % Complete
04/01/2014   Jan   Task 1   100
07/01/2014   Jan   Task 2   75
02/02/2014   Feb   Task 3   60
09/02/2014   Feb   Task 4   80
12/02/2014   Feb   Task 5   75
04/03/2014   Mar   Task 6   50
08/03/2014   Mar   Task 7   100
29/03/2014   Mar   Task 8   90
06/04/2014   Apr   Task 9   90
09/04/2014   Apr   Task 10   100
03/04/2014   Apr   Task 11   100

I know I can use a Pivot Table but I'm sure there is a SUM or COUNT formula.

Many thanks.

Susan
Logged
Atlanta Z3
Hero Member
*****
Posts: 844



View Profile
« Reply #1 on: July 10, 2014, 06:13:42 pm »

=COUNTIF(B2:B7,"<100")

correct the cell range.
Logged
SunnieG
Newbie
*
Posts: 28



View Profile
« Reply #2 on: August 14, 2014, 12:26:44 pm »

Thanks Atlanta.

That formula counts all values in the range <100. 

I am trying to find a formula that counts the number of times in a month a task is not 100% complete. 

Any assistance would be great.

Susan
Logged
Atlanta Z3
Hero Member
*****
Posts: 844



View Profile
« Reply #3 on: August 14, 2014, 03:45:31 pm »

I don't think I quite understand from your example, would task one be monthly or completed more than once a month?
What you might try is a look up color any cell under 100 red and then a formula to  count red cells by month
Logged

You will need to Login in or Register to post a message.

Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by SMF 1.1.9 | SMF © 2006-2009, Simple Machines LLC