#invalid data type

Cindy Van den Bremt

Hi,

I'm using formulas in my sheet summaries of multiple files. All work perfectly well, except on 1 more complex sheet, which contains the same columns.

Example:

=COUNTIFS([Activity type]:[Activity type], "Partner event", [Budget FY]:[Budget FY], "FY25")

The activity type & budget FY columns are both list of values.

The only difference I can think of is that in the file where it doesn't seem to work, I'm using parent rows, whereas that is not the case for the other versions. Could that have anything to do with it?

Any other ideas why things would not work?

Thanks in advancce

Paul Newcome

How exactly are those two columns you are referencing being populated?

Parent rows shouldn't be directly affecting the COUNTIFS.