View Single Post
  #3  
Old 27th February 2016, 11:53 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default

Got to love those guys on the MrExcel forum.

=IF(F1="","",COUNTA(G1:G$13)-SUM(H2:H$13))

Thamks for the help walkermac
__________________
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
_______________________________________________
Reply With Quote