Sum total with 2 conditions, but one condition is the same for all

[jackson_hollon]

Hello,

It is hard to tell what the conditions are. I have attached a file here. What I have is I have few companies that use the same number format and same invoice number. I need to sum the total by each company with their invoice. Since some of the invoice numbers will be the same. I need help on this. I do not know what formula that need to be used. Any help will be greatly appreciated.


Thanks

Jackson

[avk]

Try with "E2"

Please Login or Register  to view this content.

[FlameRetired]

Try this formula in E2 and fill down.

Please Login or Register  to view this content.

[jackson_hollon]

AVK,

Thanks for the reply. I used your formula, but the result turns out all of them with a value of E2.

Thanks again for the help.

Jackson

[JohnTopley]

Try

in E2 and copy down

=SUMIFS($C$2:$C$9,$A$2:$A$9,$A2,$B$2:$B$9,$B2)

This will total on every line.

If data is sorted as shown, then you could test for 1st occurrence of each Category/Invoice

=IF(COUNTIFS($A$2:$A2,$A2,$B$2:$B2,$B2)=1,SUMIFS($C$2:$C$9,$A$2:$A$9,$A2,$B$2:$B$9,$B2),"")