Formula help

EWRUCK

New Member
Joined
Nov 28, 2024
Messages
7
Office Version
  1. 365
Platform
  1. Windows
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:

1740852602314.png


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.

1740853063640.png


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.
 
Cannot manipulate data in a picture. Please repost your sample using XL2BB which is a built in add in from MrE.
 
Upvote 0
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 ?

Excel Formula:
=COUNTIFS(Deals2025[Deal - Deal created], [@Week], Deals2025[Ad Source], " " & V$4)
 
Upvote 0
Solution
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 ?

Excel Formula:
=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.
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top