i use this formula :to count -1 when price is NW13 cell.Formula:Please Login or Register to view this content.
how to star count from 100?
e.g. 100 (-1) = 99 (-1) = 98 (-1) = 97 (-1) = 96 ............... 0 ?
i use this formula :to count -1 when price is NW13 cell.Formula:Please Login or Register to view this content.
how to star count from 100?
e.g. 100 (-1) = 99 (-1) = 98 (-1) = 97 (-1) = 96 ............... 0 ?
Last edited by topmayra; 09-16-2018 at 05:09 AM.
Maybe
=100-SUMPRODUCT(--(B8:$B400<>""),-(B8:B400=NW13))
A formula is meaningless if we can't see the data it is manipulating.
Try this one
=100-COUNTIF(B8:NI8,$NY$9)
[ delete ]
Last edited by topmayra; 09-16-2018 at 07:18 AM.
You could apply a data validation rule to B8:NI8 using formula
=NL8>=0
Which would kick up a warning box when you try to enter more than the permitted count of 'V's in the row.
Sure
=AND(B$6<>"",$NL8>=0)
If it doesn't work as you need it to, then the other option would be to use conditional formatting, maybe turn the whole row red when =$NL8<0.
I only suggested data validation because you asked if a pop up message was possible. Data validation is the only way to do that without using vba.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks