| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sum Count of Numeric Criterion
Hi All,
I wish to sum the count of a numeric criterion across and down numerous non- consecutive Rows. The Rows of Data to be counted and summed is on every 3rd Row; starting at Row 46 - D46:AZ46, D49:AZ49, D52:AZ52 etc. Over 30 Rows to count and sum. I tried a combination of Sumproduct, Offset and Mod but could not return the correct result. Thanks, Sam -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AVERAGE Row of Numbers and Return Corresponding Numeric Label | Excel Worksheet Functions | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| Count unique alpha numeric "characters" in a common cell | Excel Worksheet Functions | |||
Threaded Mode
