| Home |
| Search |
| Today's Posts |
|
#1
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
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:B10<A1:A10),A1:A10-B1:B10) B-A: =SUMPRODUCT(--(A1:A100),--(B1:B10<A1: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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing Across Worksheets with criteria | Excel Discussion (Misc queries) | |||
| Edit multpile hyperlinks | Excel Discussion (Misc queries) | |||
| complex criteria summing | Excel Discussion (Misc queries) | |||
| Summing based on criteria | Excel Worksheet Functions | |||
| Need Help: Summing Multiple Criteria | Excel Worksheet Functions | |||
Linear Mode
