79770814

Date: 2025-09-21 11:00:08
Score: 1.5
Natty:
Report link

In addition you can return the number of products of an order ID that appear in the list with this formula. It works in my Excel 2013 sample sheet and has to be confirmed by pressing ctrl+shift+enter.

=SUM(COUNTIFS($A$2:$A$16,A2,$B$2:$B$16,$D$2:$D$4))

How do I find a cell that has a specific value from an existing list?

Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: user22566114