Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIf & multiple criteria
Excel XP
The formula =CountIf(A1:A50,"<80") counts the cells that have a value less than 80. How would I modify this formula to change the criteria to less than 80 AND more than 50? Thanks for your time. Otto |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIf & multiple criteria
Number less than 80 subtract number less than 50
=CountIf(A1:A50,"<80") - CountIf(A1:A50,"<50") You may need: Number less than 80 subtract number less than or equal to 50 =CountIf(A1:A50,"<80") - CountIf(A1:A50,"<=50") OR use SUMPRODUCT to range <80 and range 50 =SUMPROUDCT(--(A1:A50<80) ,--(A1:A5050)) For more details on SUMPRODUCT Bob Phillips http://www.xldynamic.com/source/xld.SUMPRODUCT.html J.E McGimpsey http://mcgimpsey.com/excel/formulae/doubleneg.html Debra Dalgleish http://www.contextures.com/xlFunctio...tml#SumProduct best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Otto Moehrbach" wrote in message ... Excel XP The formula =CountIf(A1:A50,"<80") counts the cells that have a value less than 80. How would I modify this formula to change the criteria to less than 80 AND more than 50? Thanks for your time. Otto |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF multiple criteria | Excel Worksheet Functions | |||
Countif with multiple criteria | Excel Discussion (Misc queries) | |||
Nesting COUNTIF for multiple criteria in multiple columns | Excel Worksheet Functions | |||
Help please - Countif with multiple criteria | Excel Worksheet Functions | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions |