| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'COUNTIF' and 'AND"
Try:-
=SUMPRODUCT((A1:A5<"")*(B1:B5="")) Extend A5 - B5 as required Mike "Jeff" wrote: I have two columns of data I want a total count (not sum) of the first column only if the corresponding second column is not blank -- Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "countif" and "and" condition | Excel Worksheet Functions | |||
| Using "Countif" in macro gives compile error | Excel Discussion (Misc queries) | |||
| I need help with a formula similar to "countif" but more complex | Excel Worksheet Functions | |||
| Logic of this formula =SUMPRODUCT((A1:A4<"")/COUNTIF(A1:A4,A1:A4& | Excel Discussion (Misc queries) | |||
| =countif (h3:h16"=01 01 2006") how to substitute cell for date | Excel Worksheet Functions | |||
Threaded Mode
