Hi All
I am struggling to know how to get an array formula working. Any help would be massively appreciated.
I need to count the number of times that the value of cell B39 shows in range A3:A33 and also the number of times that a non zero quantity is present in range E3:E33. Both criteria must be met before cell is counted.
The formula i have at present is:
{=SUM((A3:A33=B39)*(E3:E33>0))}
This returns a value of 6, as there is 6 cells in A3:A33 with the value of B39. However there is no corresponding cells in range E3;E33 with a positive value - so result should be zero.
Hope this makes sense
Thanks
Mark
Bookmarks