Count Values in 2 Columns return unique for row.

[LMCT3]

Hi,

Thanks in advance for any assistance.

=COUNTIFS(BookingsYTD!A:A,"*"&YTD!A15&"*")+COUNTIFS(BookingsYTD!L:L,"*"&YTD!A15&"*")

Trying to count "*"&YTD!A15&"*"

In Columns A:A and L:L.

This formula counts both and returns the value 2 if both columns contain that string.

The problem is in the records it could be either in A:A OR L:L OR Both. In the case that it is both, how would I return values unique to the row.

So if records list had those strings as

A:A L:L
TRUE FALSE
FALSE TRUE
TRUE TRUE

That the resulting figure would be 3 where there are 3 unique rows where any of those return TRUE.

Hopefully my explanation is sufficient. Thanks for your time everyone.

Regards,
Lewis.

 

[bebo021999]

May be:

=COUNTIF(BookingsYTD!A:A,"*"&YTD!A15&"*")+COUNTIF(BookingsYTD!L:L,"*"&YTD!A15&"*")-COUNTIFS(BookingsYTD!A:A,"*"&YTD!A15&"*",BookingsYTD!L:L,"*"&YTD!A15&"*")

 

[LMCT3]

@Bebo

Thankyou very much that's perfect, it didn't occur to me to count each column add them, then subtract the IFS. Perfection in simplicity.