Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-09-2014, 02:22 AM
MoranGail MoranGail is offline Countif function not calculating correctly Windows 7 32bit Countif function not calculating correctly Office 2010 32bit
Novice
Countif function not calculating correctly
 
Join Date: Jul 2014
Location: Griswold, CT
Posts: 1
MoranGail is on a distinguished road
Default Countif function not calculating correctly

I am trying to use a countifs function to filter data in a MS Excel spreadsheet. Below are my results. As you can see the Math (Outstanding items = previous week's outstanding items - Items Completed + new items isn't working. It doesn't look like it is counting the new items each week. When I manually filter the spreadsheet, the new items are contained in the list of the outstanding items. Below are my formulas:


Items Completed =COUNTIFS('New Items'!$BD$7:$BD$40000,"No",'New Items'!$BA$7:$BA$40000,">="&A2,'New Items'!$BA$7:$BA$40000,"<="&B2)

New Items=COUNTIFS('New Items'!$BD$7:$BD$40000,"No",'New Items'!$AN$7:$AN$40000,">="&A2,'New Items'!$AN$7:$AN$40000,"<="&B2)


Outstanding Items=COUNTIFS('New Items'!$BD$7:$BD$40000,"No",'New Items'!$BA$7:$BA$40000,">"&B2)+COUNTIFS('New Items'!$BD$7:$BD$40000,"No",'New Items'!$BA$7:$BA$40000,"")

It is always off by the number of new items.

Starting Point:03/01/14Items
Completed
New
Items
Outstanding Items03/03/1403/07/140240503/10/1403/14/140540503/17/1403/21/1481239703/24/1403/28/1455239203/31/1404/04/149338304/07/1404/11/1463137704/14/1404/18/142765350


Please help. I am new to the countifs function.
Reply With Quote
  #2  
Old 07-09-2014, 05:50 AM
gebobs gebobs is offline Countif function not calculating correctly Windows 7 64bit Countif function not calculating correctly Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 834
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Attach the sheet please.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Countif function not calculating correctly COUNTIF Formula teza2k06 Excel 3 02-13-2014 12:37 PM
Countif function not calculating correctly MS Project not calculating earned value correctly mtbtomo Project 1 10-23-2013 06:49 AM
Countif hockeytown Excel 3 01-05-2013 08:06 AM
Countif function not calculating correctly Countif issue Katy I Excel 2 07-11-2012 06:30 AM
Countif function not calculating correctly Countif with 2 criteria ibrahimaa Excel 3 05-23-2011 11:23 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 03:31 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft