Report QTY of color stock

I do not know which formula to use for this problem. We have Red, Green, Blue, Yellow and White color.

From report that we have (A2:A100) nobody selected White, the question is: How do I print A2:A to E3:E only. What printed at A2:A and how to create the SUM of Color that have been requested (F3:F)

  • The question isn't very clear (and seems like a homework assignment). Can you better explain the requirements? What is the output supposed to look like? What have you tried and what are you stuck on? – fixer1234 Jan 11 at 5:11
  • Have a try (and read) on the countif() function.. then please share what you had understand/get. ( : – p._phidot_ Jan 11 at 8:43
  • I believe =SUMIF(A:A,E3,B:B) is what you need. More info on SUMIF can be found here – cybernetic.nomad Jan 11 at 16:08
  • sorry for late respond – Grideas 16411 Jan 16 at 6:30
  • sorry for bad english, it is like we have store that selling pen,book, drawing book, and pencil. at end of month i need report what we sell. and we only sell pen, book, drawing book. Pencil is not sold. A = daily selling – Grideas 16411 Jan 16 at 6:33

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.