|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 5th, 2008, 05:06 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing differences with multpile criteria
I want to sum the difference between each row in 2 columns of data for each case where row(i) in column A 0 and row(i) in column B is less than column A 
|
|
#2
August 5th, 2008, 05:53 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summing differences with multpile criteria
So which column should be subtracted from which column?
A-B or B-A Try one of these: A-B: =SUMPRODUCT(--(A1:A100),--(B1:B10A1:A10),A1:A10-B1:B10) B-A: =SUMPRODUCT(--(A1:A100),--(B1:B10A1:A10),B1:B10-A1:A10) -- Biff Microsoft Excel MVP "TT" wrote in message ... I want to sum the difference between each row in 2 columns of data for each case where row(i) in column A 0 and row(i) in column B is less than column A
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
