Hello all, I am trying to do a sheet summary to show the Active Dealers vs Non Active Dealers that are running campaigns. An active dealer will have a monthly total greater than 0. However the Monthly…
Hi. I've been at this for hours and can't get it. I'm trying to write a formula that will pull a total count of items with a specific status for the last 60 days. Both of the formulas below work separ…
I am trying specify counting only rows that contain "UO" within the Department column, are less than one year and the withdraw/rescind column is blank. I am able to achieve the counting of withdraw/re…
Hello, I have a column that's a date and need a formula on a separate sheet to count if the date is current year. I haven't been able to find any community posts about sheet references, only cross she…
Hello I am trying to create a count if function- My current sheet, Assigned Counter needs to return a tally with each "article" assigned to a trainer. So under the articles assigned i'm trying to use …