Creating IF/AND formula

[jtmbell]

I'm working with a large excel doc that has several tabs. Trying to create a formula to tell me if there's an account number listed in column A AND if it has an X in column DJ for that specific account. If both the account number and the X in DJ are there I need an X in the new cell.


I am trying the following but it keeps coming up saying we found a problem and I have been unable to resolve using the Insert Formula tab.
=IF(countif('3.6'!A:A,A39),(AND('3.6'!DJ:DJ,DJ39),"blank","X","")


This formula below says there are too many arguments: =IF(countif('3.6'!A:A,A39),AND('3.6'!DJ:DJ,DJ39),"blank","X","")

All help is greatly appreciated!

 

[canisdibellum]

Is this formula taking up only one cell telling you the answer for multiple cells at once or is it populating a column, telling u the answer for each row?

 

[jtmbell]

The formula will be for each row. So the answer will go in column DJ on my new tab. I'm basically trying to be able to carry forward that information with each new tab from the previous tab but the account numbers in each row could be in a different order with each new tab.

 

[Joe4]

You have WAY too many arguments in your IF statement. An IF statement only has 3 arguments (condition, true clause, false clause). You have 5! I have color coded them below.
=IF(countif('3.6'!A:A,A39),(AND('3.6'!DJ:DJ,DJ39),"blank","X","")

I think you want something like this:
=IF(COUNTIFS('3.6'!A:A,A39,'3.6'!DJ:DJ,"X"),"X","")

 

[canisdibellum]

The formula will be for each row. So the answer will go in column DJ on my new tab. I'm basically trying to be able to carry forward that information with each new tab from the previous tab but the account numbers in each row could be in a different order with each new tab.

For each row u want something like:
For Row 1: =if(and(A1<>"",DJ1="X"),"BLANK","X")

 

[jtmbell]

THANK YOU @Joe4! This worked.

 

[Joe4]

You are welcome.

I hope it makes sense.
If it helps, here are links to the structures of COUNTIFS and IF:
https://www.techonthenet.com/excel/formulas/countifs.php
https://www.techonthenet.com/excel/formulas/if.php