- Summing a summary sheet report
Hi all, I have built a sheet summary report, and this is showing the data that I would expect. I would like to be able to sum each column - (i.e. one of the columns is no of reports that are live) so that I can get a total, and to put this on a Dashboard either as a Metric or have 5 or 6 columns combined in a chart. Sorry…
- Is there a way to copy Summary Fields to other sheets but not overwrite data already entered
HI, I have an issue where we have most Summary Fields that contain formulas but we have a few which are keyed in for integration with our CRM. I have created a sheet with the manual summary fields and another for formula fields but when I copy only the last set of Summary fields are stored. Additionally, when we add more…
- Is there a way to use a CountIF formula that would ignore hidden rows/cells?
Hello, I am am trying to create a summary report that would count the number of "complete", "not started", and "In Progress" with only using the rows/cells that are filtered. I do not need to count the rows/cells that are hidden but when I use the COUNTIF function, it would also count the hidden rows/cells. Thank you.
- Sheet Summary Formula Needed: Sum all numbers in a column for rows which match a criteria
Hi, I am looking for help writing a sheet summary formula that will sum all numbers in Column B for all rows matching a criteria in Column A. I have a sheet that tracks transactions by salesperson. Each row is a transaction. I have column that contains the commission for the salesperson for each transaction. In the sheet…
- How do I create a summary page or report from a Financial Donor List?
Hello, I have a sheet that tracks donations as they are received; name, email, and amount of the donation. Some are one time donors, others are repeat donors, and I would like to create a summary page that lists each individual donor and the total amount they have donated. Also, is there a way for a new donor to…
- Sheet Summary - SUM Chilldren Rows based on Status and Dates
Good Afternoon! I am trying to sum children rows where certain status' exist where the Pick-Up Date is today, within the next two days, and in the future beyond that. (Really, 3 formulas). I tried applying the following formula before involving dates to make sure the first part of logic is correct but it is giving me an…
- #INVALID DATA TYPE for some functions using DATE
Hi: I am trying to generate a sum (cumulative) of all effort "points" for projects started in the current year. CASE 1: My reference columns are: "Project Start" (date) and "Effort Count (Est. Total)" (text/number). I used the formula: =SUMIF([Project Start]:[Project Start], YEAR(@cell) = 2020, [Effort Count (Est.…
- Sheet Summary field, max date, ignore blank cells
Hi, I have a sheet with active jobs, some are scheduled and some are not. I want the Sheet Summary field to show the furthest date listed, but some of the rows do not have a date in the selected date column, and I want to be able to select the entire column to pull from so I don't have to expand the selection every time…
- How do I create a report from various forms?
Ok, so I have about 17 forms created for various employees in different departments. Each employee is required to fill out this form x amount of times a month. I want to make a report to auto populate that shows how many times employee filled out the form, and I want the report to show the employees percentage of completed…
- How can generate a weekly report using formula and without using a Column Helper?
Hi, Please help me on writing a formula to calculate the weekly sales data. Please see the attached screenshot of my example data.
