search for 2 'codes' on 1 line to return a value

[Nae2016]

Hello,

Can anyone show me the formula to search for the 2 codes (B in 1 column then X from another column) on the same line and return a value into the 1st tab on the spreadsheet?

Thank you

[Sam Capricci]

do you mean a formula like this? =IF(AND(Sheet2!A2="b",Sheet2!E2="x"),1,0)

[Sam Capricci]

OR, do you mean something like either of these?
=COUNTIFS(Sheet2!A:A,"b",Sheet2!E:E,"x")
=COUNTIFS(Sheet2!A:A,LEFT(A1,1),Sheet2!E:E,RIGHT(A1,1))

[Nae2016]

yes, something like that. Now, if I need to apply that formula to a spreadsheet where there are multiple entries (same format) not all column E will have an X (see the attached updated spreadsheet)

I need the total count of how many lines contain b&x. for some reason when I apply your formula into my spreadsheet, its coming up with a 0.

[Nae2016]

=COUNTIFS(Sheet2!A:A,"b",Sheet2!E:E,"x") was the winner!

Thanks so much Sambo Kid!