Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-29-2014, 06:25 PM
jaden0605 jaden0605 is offline multiple conditions, and blank cells with the countifs function Windows 8 multiple conditions, and blank cells with the countifs function Office 2013
Novice
multiple conditions, and blank cells with the countifs function
 
Join Date: Mar 2014
Posts: 1
jaden0605 is on a distinguished road
Unhappy multiple conditions, and blank cells with the countifs function

I am trying to use countifs for the following:

Count how many times a single letter “T” (column 1) occurs within the date range from 1/1/14 to 1/31/14 (column 2) it works fine until here.
However I have errors when I try to incorporate the following:

Not able to count occurrences of the column 3 that has part of a word (*karu) and blank cells within the same column.
Also add one if the last column has a number or do not count if is blank.


=COUNTIFS('sheet1'!$F:$F,"T",sheet1'!$E:$E,"TP",sh eet1'!$L:$L,"*KARU",sheet1'!$A:$A,">=1/1/14",sheet1'!$A:$A,"<=1/31/14")+COUNTIFS(sheet1'!$F:$F,"T",sheet1'!$E:$E,"TP" ,sheet1'!$L:$L,"",sheet1'!$P:$P,"<>3",sheet1'!$A:$ A,">=1/1/14",sheet1'!$A:$A,"<=1/31/14")

I think the problem start after the plus sign, but not sure how to concatenate another formula to do the task.

I appreciate if someone help me with this.
Reply With Quote
  #2  
Old 03-30-2014, 01:50 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline multiple conditions, and blank cells with the countifs function Windows 7 64bit multiple conditions, and blank cells with the countifs function Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi and welcome Could you please post a sample sheet ( no pics please) Thank you
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Join cells together separated by ; when some are blank leemoreau Excel 3 11-03-2013 11:22 AM
multiple conditions, and blank cells with the countifs function Replacing cells in Excel-Very basic with minor conditions mag Excel 1 10-26-2012 10:59 AM
multiple conditions, and blank cells with the countifs function Selecting blank cells in criteria apolloman Excel 6 08-24-2011 05:38 AM
multiple conditions, and blank cells with the countifs function Count with multiple conditions bundy5150 Excel 4 02-22-2011 10:00 AM
Using both drop down lists and blank cells for text voltarei Word 0 03-18-2010 04:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:54 PM.


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