0

To get the total of In Stock. I used this formula and it works. but this formula works for specific text.

=SUMPRODUCT((A2:A6="In Stock")*(B2:B6="Laptop"))

I need simpler formula to count rest user's asset count except "In Stock"

example file:

enter image description here

1
  • A slimier formula? Floor should be pretty slimy.. May 3, 2016 at 14:15

1 Answer 1

0

Put this in E2 and copy down it references the value in F2 as the one to count:

=CountIfs(A:A,"<>In Stock",B:B,F2)
1
  • It not working.
    – user589903
    May 4, 2016 at 9:34

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .