mahmed1
Well-known Member
- Joined
- Mar 28, 2009
- Messages
- 2,302
- Office Version
- 365
- 2016
- Platform
- Windows
Hi
I have this formula
=SUMPRODUCT((--((Sheet1!$A$3:$A$25+0)=DASHBOARD!$A$2))*(--(Sheet1!$B$3:$B$25>"")))
This works fine until...
(--(Sheet1!$B$3:$B$25>"")) - I though this would give me anything that is not blank whether that means text or number as it is greater than blank however it seems to ignore numbers as greater than blank and returns false so if i had 9 this returns false =B4>""
Should this be the case ? and what do i need to add to make sure anything other than blank should return a true?
Thank You
I have this formula
=SUMPRODUCT((--((Sheet1!$A$3:$A$25+0)=DASHBOARD!$A$2))*(--(Sheet1!$B$3:$B$25>"")))
This works fine until...
(--(Sheet1!$B$3:$B$25>"")) - I though this would give me anything that is not blank whether that means text or number as it is greater than blank however it seems to ignore numbers as greater than blank and returns false so if i had 9 this returns false =B4>""
Should this be the case ? and what do i need to add to make sure anything other than blank should return a true?
Thank You