| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF or SUMPRODUCT?
First of all, I would like to say I have found a lot of questions & answers
that have become useful to me in my day to day excel experience. Thanks to all the posters and the intelligent folks that have the answers! My question is... I have 2 columns of data, column A A1:A100 =RC44, column B (need to be less < than 74) count as 1 EXAMPLE: Column A Column B RC44 60 RC44 77 RC52 14 RC60 58 RC44 72 If coumn A = RC44 & column B is less than 74 should =1 (or example above is= 2) Can anyone provide any help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumproduct vs. countif | Excel Discussion (Misc queries) | |||
| Sumproduct, If, Sumif, Countif, Match?? | Excel Discussion (Misc queries) | |||
| countif more than one sheet/tab and sumproduct | Excel Worksheet Functions | |||
| countif, sumproduct | New Users to Excel | |||
| Using COUNTIF with 2 criteria - SUMPRODUCT? | Excel Worksheet Functions | |||
Threaded Mode
