Complicated Excel Forumal (to me!)

[FannyAdams73]

I have a formula to put into my spreadsheet that does the following:

In the first sheet I have a column which contains lines with th
following statements:

Link Ordered
Link Despatched
Link Delivered

I need to sum the total number of each of these in the next sheet i
the summary page as try as I may, I cannot get it to appear how I nee
to to.

So the summary sheet should say e.g.

Link Ordered 21
Link Despatched 43
Link Delivered 102

(these should then automatically change as the status of the lin
changes on the first sheet)
Please help!

Many thanks

 

[Eduardo]

Hi,

I assume the sheet where you have the data is called "Data", column A has
the names and column B the numbers to be added, then in the summary sheet in
column A you have the names and in column B you want the sum of the
information so in the summary sheet cell B2 enter

=SUMPRODUCT((A2=Data!A1:A19)*Data!B1:B19)

change range to fit your needs, range have to be the same in both sides of
the formula

 

[teylyn]

Hi FannyAdams,

welcome to TheCodeCage!

you could also use Sumif(). It will be faster than Sumproduct()


=SUMIF(Sheet2!$A$1:$A$10,A1,Sheet2!$B$1:$B$10)

If that does not help, please attach a file with some sample data.

cheers

Attachments.

To upload a workbook, click reply then add your few words, scroll down
past the submit button and you will see the Manage Attachments button,
this is where you get to add files for upload, if you have any trouble
please use this link or the one at the bottom of the
any page.