Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
U812B4
Lv 4
U812B4 asked in Computers & InternetSoftware · 1 decade ago

Microsoft Excel Question!?

I have (2) columns, under A1 I indicate Part Numbers (Ex: 173,174,175, etc). In the second column I indicate the value of cases built, (Ex: 23, 42, 50, etc).

My question is what kind of a formula would allow me to search for all the entries with part number 175 for example and give me the total cases built? Sometimes I have multiple entries with the same part number.

Thanks!

1 Answer

Relevance
  • Anonymous
    1 decade ago
    Favorite Answer

    Use sumif

    SumIf( range, criteria, sum_range )

    =sumif(A:A, "175", B:B)

Still have questions? Get your answers by asking now.