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
Boolean operator in Excel?
I use excel to keep track of my billing. When I send out an invoice, I put a "n" in a column titled "Have they paid me yet?" and delete the n when the check comes in. I want a formula that looks at that column, and for every n it finds, adds and totals the dollar value of those invoices into another cell. That way I can see how much money I would have if my clients actually paid me on time, and then cry.
Can you write a mock equation for me?
That was it! Now, as soon as I figure out how to award the points, you get them.
2 Answers
- expletive_xomLv 71 decade agoFavorite Answer
you can use the sumif() formula
A1 to A10 has random n and blanks
B1 to B10 has random amounts
then copy&paaste this in C1
=SUMIF(A1:A10,"=n",B1:B10)
its not case sensitive
while you are at it, you can count the number of n's with the countif() formula
=COUNTIF(A1:A10,"=n")
you would need a true boolean if you added a 3rd criteria like a customer#..in that case sumproduct() would be my formula of choice.
