Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting differences in numbers across columns
I think this is probably pretty easy.
I have a table here is the first row (starting at a1), with numbers in individual columns A B c d e 1624 1433 1546 1244 1287 The columns represent years with A being the current year. I want to count how many years improved upon the previous year. The answer is two, C is greater than D, and A is greater than B. Of course units went down from E to D and again from C to B. How do I write a formula that can analyze the four relationships across the five years and count how many times units went down from one year to the immediately following year? |
#2
|
|||
|
|||
One way:
=SUMPRODUCT(--(A1:D1B1:E1)) HTH Jason Atlanta, GA -----Original Message----- I think this is probably pretty easy. I have a table here is the first row (starting at a1), with numbers in individual columns A B c d e 1624 1433 1546 1244 1287 The columns represent years with A being the current year. I want to count how many years improved upon the previous year. The answer is two, C is greater than D, and A is greater than B. Of course units went down from E to D and again from C to B. How do I write a formula that can analyze the four relationships across the five years and count how many times units went down from one year to the immediately following year? . |
#3
|
|||
|
|||
Thanks Jason, that worked great, I just needed change the '' to a '<'.
Big help!! "Jason Morin" wrote: One way: =SUMPRODUCT(--(A1:D1B1:E1)) HTH Jason Atlanta, GA -----Original Message----- I think this is probably pretty easy. I have a table here is the first row (starting at a1), with numbers in individual columns A B c d e 1624 1433 1546 1244 1287 The columns represent years with A being the current year. I want to count how many years improved upon the previous year. The answer is two, C is greater than D, and A is greater than B. Of course units went down from E to D and again from C to B. How do I write a formula that can analyze the four relationships across the five years and count how many times units went down from one year to the immediately following year? . |
#4
|
|||
|
|||
=SUM(IF(B2:F2A2:E2,1,0))
which is an array formula, so commit with Ctrl-Shift-Enter -- HTH RP (remove nothere from the email address if mailing direct) "Ted Metro" wrote in message ... I think this is probably pretty easy. I have a table here is the first row (starting at a1), with numbers in individual columns A B c d e 1624 1433 1546 1244 1287 The columns represent years with A being the current year. I want to count how many years improved upon the previous year. The answer is two, C is greater than D, and A is greater than B. Of course units went down from E to D and again from C to B. How do I write a formula that can analyze the four relationships across the five years and count how many times units went down from one year to the immediately following year? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
identify numbers which are listed in two columns. | Excel Worksheet Functions | |||
Sum of all even and odd numbers between two columns | New Users to Excel | |||
How to sort random numbers in columns | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
How do I take two columns of sequential numbers and insert spaces | Excel Discussion (Misc queries) |