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.

Eric asked in Computers & InternetSoftware · 4 years ago

How can only count certain cells in excel 2013.?

So I m trying to keep track of my overtime hours per week. In column A is have my goal hours, and in column B is the hours actually worked. So I have column A filled out and column B will be filled in as the weeks go on, and the total amounts of each column will be added up in a cell at the bottom of the list. Adding column B is easy. What I need help doing is counting column A. I want to only count the cells corresponding to weeks that have already been worked. So say I have A1-A10 all with a value of 8 goal hours for those 10 weeks. And I ve only worked 3 weeks B1-B3 and I worked 9 hours each of those weeks. So I want B11 to say 27 and A11 to say 24. Is there a way I can have the cells in column A only counted as the cell in Column B is entered.

1 Answer

Relevance
  • 4 years ago
    Favorite Answer

    sure,

    you would use the SUMIF() function

    heres your formula for A11

    =SUMIF(B1:B10,">0",A1:A10)

    it just checks if B1 to b10 has a number is in, and if it does, then it adds up the # in the A column next to the number in the B column.

    let me k now if that works for you (looks like Yahoo is finally back up and running again)

Still have questions? Get your answers by asking now.