• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extracting Data from a Table and Summing

K

kensbro

New Member
I have this table of data with column headers as follows..."School Code", "ISBN", "Cost",etc...Is there a formula or combination that will (1) extract all the ISBN's for a particular "School Code", then (2)Multiply each extracted record by its associated cost? I am trying to avoid pivot tables because i would like the results displayed in a new column.
 
Kensbro


Yes


Sumproduct should do the trick


I'd read a few of the posts here about it as a start
 
As Hui said. Use Sumproduct as an array.


=sumproduct((schoolcoderange=schoolcode)*(ISBNrange)*(costrange))
 
You must log in or register to reply here.
Back
Top