summing groups of fields....like totaling an invoice

I have an excel table which expresses invoices generated. Rows are used one by one to display each item on that invoice. Column “D” displays the part number.  Column “C”  lists the invoice number,.
So if invoice 2110 has two items on it, there will be two rows representing this invoice. Each having a identical value in column C.

Column R shows the extended value of each row. I would like to accumulate the sum column of R for a group of rows pertaining to the same invoice number, as shown in column c,   and display that answer in column S.
Therefor if done properly… S will have only one value for each invoice ( which may be represented by 2 or more rows ).
I have up loaded a sample file.....
Can u help.
Starlight-Invoices-test.xlsx
intelogentAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
nutschConnect With a Mentor Commented:
I'm actually recalculating R based on qty and price columns in the sumproduct. Using column R, it would be:

=IF(C4<>C3,SUMif(C$3:C3,C3,R$3:r3),"")
0
 
nutschConnect With a Mentor Commented:
In cell S3:

=IF(C4<>C3,SUMPRODUCT((C$3:C3=C3)*E$3:E3*F$3:F3),"")

and copy down.

Thomas
0
 
intelogentAuthor Commented:
not so fast...

firstly   it works... but it is spookey.....

how is it totaling "R"  when "R" is not mentioned in your formulas?

its not a perfect answer until I understand... :) :)
0
 
Rob HensonConnect With a Mentor Finance AnalystCommented:
Alternative to get a summary table would be to use a pivot table with Invoice number as a row header.

Thanks
Rob H
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.