LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 160
Default COUNTIF with 2 variables. HOW???

Here is what I am trying to do. In a cell I want it to look at a range of
other cells with the "COUNTIF" formula. I want to be able to say to a
particular cell, for example:

Look at the range of cells A1:Z1. Count them if the value is 0 and <2.5.

For some reason I just can't seem to get it to work or to get Excel to tell
me what I'm doing wrong!!! HELP!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
COUNTIF formula with several variables in 1 column NitaMax Excel Discussion (Misc queries) 3 February 8th 07 02:35 AM
countif two variables in two different columns Greg Diamond Excel Worksheet Functions 2 May 25th 05 07:58 PM
Countif function with variables SMANDA Excel Worksheet Functions 0 February 7th 05 10:46 PM
another thought on COUNTIF 2 VARIABLES ?? Alan Excel Worksheet Functions 1 November 27th 04 03:25 AM
COUNTIF ON 2 VARIABLES ?? Alan Excel Worksheet Functions 4 November 26th 04 08:10 PM


All times are GMT +1. The time now is 01:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"