Syntax Help - Sumif and AND

[Jay3]

Hi,

Can someone tell me how to cross reference a sumif / countif using an AND for 2 criteria.

I want to say if the NAME = John and the DATE = 01/07/2018 then sum.

My names are in the column and the dates are in rows.

Can someone help with the syntax.

Cheers,
John

 

[Aladin Akyurek]

Why don't you post a sample to avoid any communication problem?

=SUMIFS(INDEX(DataRange,0,MATCH(DATE,INDEX(DataRange,1,0),0)),INDEX(DataRange,0,MATCH("Name",INDEX(DataRange,1,0),0),NAME)

 

[Learn Excel in Tamil]

Hi Jay,

Please refer the syntax for your reference "=IF(A1="John",IF(B1=DATE(2018,1,7),SUM(Your Range),"False"))"

Thanks
Let