Hello everyone,
I got a formula like this:
This formula is a bit too long. I am wondering if I can combine them into a more simple one so that there are not too many repetitive SUMPRODUCT.Please Login or Register to view this content.
Hello everyone,
I got a formula like this:
This formula is a bit too long. I am wondering if I can combine them into a more simple one so that there are not too many repetitive SUMPRODUCT.Please Login or Register to view this content.
How about, assuming you do not have any negative values
=SUM(COUNTIF(A1:A100,{"<=2",""}))
If you do have -ve values
=SUM(COUNTIF(A1:A100,{"<=2",""}))-COUNTIF(A1:A100,"<0")
Last edited by Fluff13; 12-22-2019 at 05:54 PM.
Another possibility?Formula:Please Login or Register to view this content.
Dave
Many thanks, sir. It works perfectly for me Thanks for the great help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks