Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Challlenging COUNT IFS?
This has become quite challenging. IF in range d23:023 there are only zeros, nothing[s], or a mix of both, would like cell q23 to return zero, otherwise 1. Cant use a sum because sometimes there are offsetting numbers, ie +100 and -100 in the same row that would return 0. Some cells in the range are a formula [which is why theres a zero], others are just blank. The end result is to import a large table into Access, using row q as import criteria, so Access does not import any rows that are meaningless. In other words, if *something* is in the row, put a 1 in column q, if there is nothing meaningful in the row [zeros or nothings] put a zero in column q. Have tried numerous COUNT IFS formulas to no avail. Any assistance would be sincerely appreciated. Thanx, - Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
Excel Count characters in a textbox to display character count? | Excel Programming | |||
How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |