Array formula

Hi Kate,

Sorry I do not understand what you want. The Index functions arguments =Index(array, row number, Column number). I assumed that reg was a range name. The Index function can only return the content of one cell.

What do you have in the cells C73 to C79? Do you have column numbers in the cells C73 to C79?

I do not know if you can send me the worksheet.I need to see the data or a dummy file, where the data are organised the same way as your data.

You can count with Sumproduct but you cannot sum up a count with the sum function.

If you can send me an example file, please send it to:

info@stl-training.co.uk

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Hi Kate,

You cannot use wildcards inside a Sum function, but if you only
have the word charity in column 2 try this:

=SUM((ISNUMBER(FIND("Charity",REG)))*
(INDEX(REG,,$C$74)=$E$6)*
(INDEX(REG,,$C$75)="Registration")*
(INDEX(REG,,$C$76)=$B$86)*
(INDEX(REG,,$C$77)=$C$84)*
(INDEX(REG,,$C$79)<$B9)*
(INDEX(REG,,$C$79)>=$B8))

Please let me know if it is not working.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector