27th February 2016, 11:30 PM
|
Member
|
|
Join Date: Jan 1970
Location: Western Australia
Posts: 3,457
|
|
They came up with a similar code to your, just more compact.
=IF(F1="","",COUNTIF(G1:G$13,"?*")-SUM(H2:H$13))
__________________
One Drive
"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________
|