Query & Countif Formula

[yvettew78]

I need to report daily stats in google sheets and need help with the formula.

For example, In the data sheet, column A is the "DATE" column and column G is the "LEAD SOURCE" column. I want it to find "TODAY'S" date first (Column A), then count how many "FACEBOOK" leads we have received on that date (Column G).

 

[mrshl9898]

=COUNTIFS(A:A,TODAY(),G:G,"Facebook")

 

[yvettew78]

=COUNTIFS(A:A,TODAY(),G:G,"Facebook")

Hi there - thanks for your help.

I have slightly changed it to:-

=COUNTIFS('Data'!A:A,TODAY(),'Data'!G:G,"Facebook"))

However it still doesn't populate the total "FACEBOOK" leads. It shows "0".

Any idea why?

 

[mrshl9898]

Are the dates in column A numeric and also not datetime?

 

[mrshl9898]

Try =A2=INT(A2) to test

 

[yvettew78]

Are the dates in column A numeric and also not datetime?

I have just changed it to Numeric - is that right?

 

[mrshl9898]

Are the numbers whole numbers?

 

[yvettew78]

Try =A2=INT(A2) to test

A4 is the first cell that contains a date, so I changed it to A4, instead of A2 and it says Function INT parameter 1 expects number values. But '24.08.2020' is a text and cannot be coerced to a number.

 

[yvettew78]

Are the numbers whole numbers?

I try to change it but it doesn't do anything?

 

[mrshl9898]

Text, ok. Try

=COUNTIFS( 'Data'! A:A,TEXT(TODAY(),"DD.MM.YYYY"), 'Data'! G:G,"Facebook")