| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif with AND comparing 3 columns
Thanks, workrf perfectly!!!!!!!!!!!!!!!!
"smartin" wrote: Johndb wrote: Need help. Ineed to add an AND command to the following formula and can't seem to figure it out. =SUM(IF(ISNUMBER(G3:G37),IF(ISNUMBER(H3:H37),IF(H3 :H37=G3:G37,1,0)))) It also needs to check if b3:b37 is = to "S" Any assistance would be geatly appreciated. Warmest Regards, John Two ways: =SUMPRODUCT(ISNUMBER(G3:G7)*ISNUMBER(H3:H7)*(G3:G7 =H3:H7)*(B3:B7="S")) Array* formula: =SUM(IF(ISNUMBER(G3:G7)*ISNUMBER(H3:H7)*(G3:G7=H3: H7)*(B3:B7="S"),1)) *An array formula must be committed by pressing Ctrl+Shift+Enter. Do not just press Enter or Tab. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif comparing two columns | Excel Worksheet Functions | |||
| comparing 2 columns | Excel Discussion (Misc queries) | |||
| comparing 2 columns | Excel Discussion (Misc queries) | |||
| COUNTIF/SUMIF comparing two rows of data | Excel Worksheet Functions | |||
| Comparing two columns of information with 2 new columns of informa | Excel Discussion (Misc queries) | |||
Hybrid Mode
