Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
If I have 26 tabs A:Z,
and in the P columns of each tab, there are various numbers such as: 0,-100, -400,-70, 100, 400, 70, etc. I'd like to count how many a between -100 and +100 & bewteen -399 and + 399 ( not including the -100/+100 above) & <-400 and 400. Thanks, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
Funtion multi conditions | Excel Worksheet Functions | |||
Multi Column Sum and conditions | Excel Worksheet Functions | |||
SUMPRODUCT + multi conditions | Excel Worksheet Functions | |||
Multi-conditions with SUMPRODUCT and COUNTIF | Excel Worksheet Functions |