Countif function

[SanFranz]

Hi All,
Could you please suggest how can I amend this formula whereby I can replace the part of countif(I10:I11:I13:I14:I16:I17:I18:I19:I20:I21:I28 as I would consider those as single cells rather than a series? In fact the cells in between the selection e.g. I12,I15 still applies the countif function and they shouldn't. In fact, if I replace the : with , the formula has too many conditions and I get stuck

=IF(SUM(L9:L21)*100+IF(SUM(COUNTIF(I10:I11:I13:I14:I16:I17:I18:I19:I20:I21:I28,'FATF Feb23'!B5:B17)),48,0)>48,48,((SUM(L9:L21)*100)))

 

[SanFranz]

Any help please?

 

[cadandcode]

Try to use more countifs in brackets in order to specify cells which you want to consider instead of using an array like I10:I28 since that includes the cells which you dont want to consider like I12,I15 and probably the cells after I21 to I27 too.

 

[SanFranz]

Try to use more countifs in brackets in order to specify cells which you want to consider instead of using an array like I10:I28 since that includes the cells which you dont want to consider like I12,I15 and probably the cells after I21 to I27 too.

Thank you. I used that approach but still the result ends up in error...

 

[cadandcode]

Can you use XL2BB to be able to share your minisheet easily? (until some veterans approach here, I could take a look )

Thank you. I used that approach but still the result ends up in error...

 

[SanFranz]

Can you use XL2BB to be able to share your minisheet easily? (until some veterans approach here, I could take a look )

thank you. I'm new here and I have no idea where to locte XL2BB, actually I can update a spreadsheet with an update formula I would need to use..

 

[cadandcode]

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

thank you. I'm new here and I have no idea where to locte XL2BB, actually I can update a spreadsheet with an update formula I would need to use..

 

[SanFranz]

I'm attaching a picture here, hope it is ok.
Thank you!

 

[SanFranz]

Any help please?

 

[SanFranz]

Can you use XL2BB to be able to share your minisheet easily? (until some veterans approach here, I could take a look )

Hi mate,
Did you manage to look at the picture? I really need someone helping on this as I have to fix it at work
Thank you