COUNTIF data from anothher tab

Hi guys,

I think i need to use a countifs function for two problems.

Firstly
I am trying to use my 2nd tab ('Data' tab), to count how many times the word Jones comes up in column F from sheet 1, but matching the date... the date is on column A on the data tab and column C on sheet1. I want this data on cell D2 on the Data tab please

I am trying to use my 2nd tab ('Data' tab), to count how many times the Jones (column F) has cells in column I which are not empty, but match the date... the date is on column A on the data tab and column C on sheet1. I want this data on cell E2 on the Data tab please


Please help, thank you!

what you have in Data sheet D1 is "Jones number", but sheet1 is just "Jones". change D1. you also referred to column I instead of F. so:
=COUNTIFS(Sheet1!F:F,D$1,Sheet1!C:C,$A2 )

same for E1, just "Jones". and:
=COUNTIFS(Sheet1!F:F,E$1,Sheet1!C:C,$A2,Sheet1!I:I,">""")

thank you, this helps!