Sumif

[RLJ]

I am using this formula to total numbers from I5:I105 if they match the Date from A2 in C5:C105 on the sheet Alexis King. This is working perfectly... Now I need to add another condition to it.

If the conditions above are met, then I need it to look in B4 of the current sheet and if A5:A105 on Alexis King meets the criteria then total the numbers from I5:I105 on Alexis King.

So I need it to match both condiditons from A2 and B4.

=SUMIF('Alexis King'!$C$5:$C$105,$A$2,'Alexis King'!$I$5:$I$105)

Can this formula add in another criteria?

 

[njimack]

=SUMPRODUCT(--('Alexis King'!$C$5:$C$105,=$A$2),--('Alexis King'!$A$5:$A$105=$B$4),('Alexis King'!$I$5:$I$105))

 

[RLJ]

I'm getting a circular reference warning and it is not calculating.

 

[njimack]

I'm getting a circular reference warning and it is not calculating.

What else have you got going on? Which cell has the circular ref?

 

[RLJ]

My Fault. It is early where I am and my brain was not thinking correctly. I fixed it.
Thanks