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