Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-17-2015, 02:32 AM
snowweb snowweb is offline Using Countif() to select fields to be included in computation Windows 7 64bit Using Countif() to select fields to be included in computation Office 2007
Novice
Using Countif() to select fields to be included in computation
 
Join Date: Oct 2015
Posts: 2
snowweb is on a distinguished road
Smile Using Countif() to select fields to be included in computation

I am making a spreadsheet to track learning of multiple documents by multiple employees. It has the following columns:



1) list of documents
2) number of estimated hours to study each document
3) y/n whether this document is "required" learning or not.
4) y/n whether studying it is completed
5) One column for each employee who has to accomplish the learning.

Under each employee's name (for example column "i3") I have a field for "Additional Hours Needed". I want this to display the total time needed to learn all documents which are as yet unlearnt but are marked as required but I can't get the syntax right for the formula.

Currently, the formula I have is:

=IF(COUNTIF(F4:F38,"y") AND COUNTIF(I4:I38,"<>y"),E4:E38,0)

The result of that is "#VALUE!"

Where:
F4:F38 is the range of y/n whether the learning is "required"
I4:I38 is the range where the y/n is recorded concerning whether the user has completed the item
E$:E38 is the range where the number of hours estimated to learn each document from scratch is stated.
The result (number of hours remaining) should be stored in I3

I have attached a cut down version of the spreadsheet.

Maybe someone could show me what I'm doing wrong please?
Attached Files
File Type: xlsx Knowledge Transfer Tracker (for assistance).xlsx (14.5 KB, 11 views)
Reply With Quote
 

Tags
countif



Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Countif() to select fields to be included in computation How to use the icons for macros included in Word programmatically dherr Word VBA 6 03-27-2015 01:05 AM
How do you get the DATE and TIME fields to be included in an export to Excel? tpieples Outlook 0 02-18-2013 12:11 PM
Using Countif() to select fields to be included in computation Building Blocks not included in Attached Template rphox2003 Word 10 07-29-2012 04:51 AM
Using Countif() to select fields to be included in computation Greek letter phi not included in MS 2010 TurboEnginerd Word 2 07-20-2011 11:27 PM
When Printing a file Sources/Details included BigTunz Word 0 03-01-2010 01:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:50 PM.


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