| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF?? SUMIF??
I need to count the rows only if these two conditions exist in the same row.
Column A must be a specific numerical value and column B must contain any text. Thanks... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF?? SUMIF??
I assumed your range is row 1:100, change to fit your data:
=SUMPRODUCT(--(A1:A100=your_numerical_value),--(ISTEXT(B1:B100))) -- Regards, Dave "Vegs" wrote: I need to count the rows only if these two conditions exist in the same row. Column A must be a specific numerical value and column B must contain any text. Thanks... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forget SUMIF, COUNTIF and VLOOKUP | Excel Worksheet Functions | |||
| problems with sumif and countif | Excel Discussion (Misc queries) | |||
| Reference Cells with Sumif or Countif | New Users to Excel | |||
| Modify SUMIF and COUNTIF to work with SUBTOTALS | Excel Worksheet Functions | |||
| Countif, Sumif, If - help! | Excel Worksheet Functions | |||
Linear Mode
