# [email protected]’s Profile

points
328

Im close on a sumifs formula, but for some reason i cant quite get it.

trying to count installations on a give date from a given list of properties

Here's what i have. it's returning a unparceable response

=SUMIFS({7900 Park Central Install QTY}:{7900 Park Central Install QTY}, {7900 Park Central

I have a date column for installs. I also have a column where we enter a quantity.

I am trying measure installs on each day of the month.

We want to be able to look at a particular date and see how many installs we have on this date.

Im thinking a roll up sheet with each

I have a helper column (checkbox) that fills the checkbox in if the "D/I" date is past 14 days...30...45, AND IF "install date" is blank.

Here's the formula i have that seems to be working so far

=IF([D/I]@row < TODAY(-14), IF(ISBLANK([Install Date]@row), 1, 0))

couple of ?'s...

1. If i fill in the

i have a vacation calendar sheet. I am using the networkdays formula to calculate vacation days

=NETWORKDAYS([Start Date]10, [End Date]10).

The problem is that if there is not a start date and and end date entered into the cell it comes back with an "invalid data type." I am also using a formula to

I am trying to calculate revenue for Q2 only for a given property

Here's what i had in the cell

=SUMIFS({Garden Grove Bill Rate}, {Garden Grove Inv Date}, YEAR(@cell) = YEAR(TODAY()), {Garden Grove Inv Date}, MONTH(@cell) > 3).

But that formula doesnt work now that we are in july. as it calculates

I am trying to calculate the total amount of invoices, from a given contractor, within a given date range.

Im not sure how to write a formula to calculate within a specific date range.

I have the formula to calculate the total invoices for an individual. But not sure how to insert date range into

We have contractors that we pay every 2 weeks. I created a form for them to upload invoice info into. I also created a report that pulls the individual invoice totals. What i want to create is a rollup sheet that will give me a total of that week's invoices for a given contractor. So for

Looking for some help writing a formula multiple criteria...

I want the formula to read the column "openings" and determine cost based on how many openings in the job.

11-20 openings = \$225 / 21-25 openings = \$250, etc...

I tried building the formula with mutlitple IF statements, but i keep getting

I shared a report with a customer. When the customer opens the report it is blank. It doesnt show any of the data?

I tried sending a link to the report as well. Still nothing in the report.