have a count based on 2 columns in a different sheet

[Jaffa_ca]

Hello all

I'm not the best at excel yet but my skills are growing thanks to reading and trying many of the thing i've read on here.

my current problem is rather tricky (or at least for me). maybe it the formula that i'm trying to use, which is the countif formula

what i'm trying to do is have excel count if 2 columns are true.

example

column A has the dates and Column B has Numbers like exampled below and I want the formula to both count the date and the number, so if i was looking for how many times on July 1st 2019 the number 1 appeared it would show me 2 i've tried the countif formula using multiple ranges and criteria, but i get an error each time. I know i am doing something wrong, i just can't pinpoint it yet


A B
07/01/2019 1
07/01/2019 1
07/01/2019 2
12/01/2019 1
12/01/2019 1

Thanks
J

 

[kweaver]

One way is to use SUMPRODUCT: =SUMPRODUCT((A1:A5=DATEVALUE("7/1/2019"))*(B1:B5=1))

If the date you're looking for is in C1 and the value is in D1, use: =SUMPRODUCT((A1:A5=C1)*(B1:B5=D1))

 

[Jaffa_ca]

Awesome thanks, I never thought of that obviously, I was to focused on "counting"