Formula help

[EWRUCK]

Hi, I thought I had my formula right and using the proper one for this case but I'm not getting any data pulled and I know there is data that should be coming back.

Purpose, I'm trying to count the number of times the header was used as source for the appointment scheduled. The data for the source is in another tab and that will be updated frequently, but this should not change the count I'm looking for.

Here is the formula I am using:
=COUNTIFS(Deals2025[Deal - Deal created],[@Week],Deals2025[Ad Source],DailyLeadsTBL[[#Headers],[Meta]])

Here is the set up for the location where my formula is at:

These are the columns where I'm pulling the source by appointment date to get a count. Notice there is a space before the Ad source which is from a data validated list so when I pull into a pivot table, I can take out sum or count of. I'm hoping this is not the cause of my issue but if so please let me know.

As you can see, Jan 1 there is 3 PPC created via but Column X is coming back as 0. What am I missing here? I'd appreciate any input or advice to help get me unstuck.

 

[alansidman]

Cannot manipulate data in a picture. Please repost your sample using XL2BB which is a built in add in from MrE.

 

[Alex Blakenburg]

You are not showing row references but assuming your headings are in Row 4 and the Data starts in Row 5, then what happens if you put the below in V5 and copy it to the right ?

=COUNTIFS(Deals2025[Deal - Deal created], [@Week], Deals2025[Ad Source], " " & V$4)

 

[EWRUCK]

You are not showing row references but assuming your headings are in Row 4 and the Data starts in Row 5, then what happens if you put the below in V5 and copy it to the right ?

=COUNTIFS(Deals2025[Deal - Deal created], [@Week], Deals2025[Ad Source], " " & V$4)

Adding in the " "& is where I was held up at. Thank you for that break through. I am very appreciative of your help.

 

[EWRUCK]

Cannot manipulate data in a picture. Please repost your sample using XL2BB which is a built in add in from MrE.

I don't have access to use XL2BB on my work laptop through our IT department. Otherwise I would.

 

[Alex Blakenburg]

Thanks for letting us know. Glad we could help.