I am trying to do something similar to this:
=COUNTIFS('Sheet2'!C:C,("<"&D10),'Sheet2'!J:J,OR((">"&D10),""))
The part that doesn't work is the "or"
I am trying to do something similar to this:
=COUNTIFS('Sheet2'!C:C,("<"&D10),'Sheet2'!J:J,OR((">"&D10),""))
The part that doesn't work is the "or"
Think you'll have to do
=COUNTIFS('Sheet2'!C:C,"<"&D10,'Sheet2'!J:J,">"&D10)+COUNTIFS('Sheet2'!C:C,"<"&D10,'Sheet2'!J:J,"")
You are awesome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks