Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello all, I am having difficulty integrating a third condition into a
complex IF statement. I have data on one worksheet and my table with formulas on a separate worksheet. I want to know how many records (2:1996) have a value of "S" when column A="1" AND column D="X". I can check for one value using the formula =SUM(IF(Cleaned!D2:D11996="x",IF(Cleaned!H2:H11996 ="S",1,0),0)) But I cannot figure out how to make it check both columns before totaling the frequency of "s". Any help is greatly appreciated. Leslie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting Rows With Non-Needed Data between Needed Data | Excel Worksheet Functions | |||
Formula needed for adding every nth column on another sheet | Excel Discussion (Misc queries) | |||
macro or function help needed for adding columns for values missin | Excel Discussion (Misc queries) | |||
R2 Help Needed | Excel Discussion (Misc queries) | |||
Adding and Deleting rows - update formulas help needed. | Excel Worksheet Functions |