N
novice
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
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