Excel formula help needed.
I currently use this formula
=IF(A1="","",IF(A1="end","",MATCH("?*",INDEX(A:A,1+MATCH(B1,A:A,0)):A$1048576,0))) to get this result. Excel 2010
Sheet1 But what i need is for it to be modified to ignore blank spaces so i can get this result. Excel 2010
Sheet1 |
I hacked at your code and got the following, which appears to work:
Code:
|
Got to love those guys on the MrExcel forum.
=IF(F1="","",COUNTA(G1:G$13)-SUM(H2:H$13)) Thamks for the help walkermac |
Sorry, both those formulas still count the space because it has a formula in it.
|
They came up with a similar code to your, just more compact.
=IF(F1="","",COUNTIF(G1:G$13,"?*")-SUM(H2:H$13)) |
All times are GMT +10. The time now is 07:14 PM. |
Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.