Yahoo Answers is shutting down on 4 May 2021 (Eastern Time) and the Yahoo Answers website is now 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.

ck40711
ck40711 asked in Computers & InternetSoftware · 6 years ago

I need help with a SUMIF formula in excel?

Update:

I am trying to do a sumif formula. In the example below "AAPL" is a value that is stored in field A2 of Worksheet 1. I want to write the formula so that it reads the value of A2 in Worksheet 1 instead of reading my hard coded value of "AAPL"

=SUMIF('Worksheet 1'!E$1:E$100807, "AAPL", 'Worksheet 1'!H$1:H$10807)

2 Answers

Relevance
  • expletive_xom
    Lv 7
    6 years ago
    Favourite answer

    here you go

    =SUMIF('Worksheet 1'!E$1:E$100807, 'Worksheet 1'!A2, 'Worksheet 1'!H$1:H$10807)

    it should just work with a copy&paste

    let me know if its working or not

  • minskey
    Lv 4
    5 years ago

    Help Sumif

    Source(s): https://shorte.im/baenX
Still have questions? Get answers by asking now.