Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
A twist on sumif?
I'm trying to sum column B by 2 conditions (columns A and C) and display the summation and the 2 conditions that match. The example below is very short, but there are approx. 100 conditions for column A and C that form many comibinations. I need to display the conditions (that both need to be met) with the summation. For example (the data is much larger than this): A B C 13-0506 Striping Contract 10.00 610 13-0506 Striping Contract 5.00 480 13-0506 Striping Contract 4.00 480 13-0501 Maint Job Inspection 2.00 610 13-0506 Striping Contract 2.00 610 Desired result: A B C 13-0506 Striping Contract 12.00 610 13-0506 Striping Contract 9.00 480 13-0501 Maint Job Inspection 2.00 610 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
How can I convert a group of numbers to a group of letters? | Excel Worksheet Functions | |||
Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions |