# Count Values in 2 Columns return unique for row.

#### LMCT3

##### New Member
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.

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
May be:

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

@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.

Replies
1
Views
1K
Replies
1
Views
203
Replies
1
Views
229
Replies
11
Views
428
Replies
5
Views
688

1,220,977
Messages
6,157,179
Members
451,402
Latest member
Lyv

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back