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

 

[yvettew78]

Text, ok. Try

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

Yay that works - thanks so much.
just one more question, what if the date is merged, rather than noted on each row? For example, I have 5 new rows but I only show the date in the first row and merge them or do I have to enter a date in each row for it to work?

 

[mrshl9898]

Would need to be in each, VBA might be an option without but i'm not sure how that works with Google Sheets.

 

[yvettew78]

Text, ok. Try

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

Also, if I want to add the date rather than use "TODAY", what would be the correct format?

 

[yvettew78]

Would need to be in each, VBA might be an option without but i'm not sure how that works with Google Sheets.

Oh ok i will just enter the date in each row then maybe

 

[mrshl9898]

Since they aren't really dates, you should be able to use:

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

 

[yvettew78]

Since they aren't really dates, you should be able to use:

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

Awesome - thanks so much for all your help!!!

 

[mrshl9898]

No worries