Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct (I think?)
I have two ranges A1:A100, B1:B100 each containing single digit numbers
typically between 3 and 8. (No blank cells. I would like to count all the instances of each time row B contains a number one less than that in the equivalent A cell. eg if A5 contains 6 and B5 contains 5 then that would count as one instance. The pairs have to be the same numbers. further eg A10 containing 6 and B10 containing 5 would count as a second instance but A12 containing 7 and B12 containing 6 would not. Am I making sense? TIA Sandy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
Sumproduct | Excel Worksheet Functions | |||
Sumproduct? | Excel Discussion (Misc queries) | |||
SUMPRODUCT Help | Excel Worksheet Functions | |||
SUMPRODUCT Help | Excel Worksheet Functions |