-
Clock Hour Progress Management
Hello, My name is James Smith. I am an Instructor for Gateway Community College in Phoenix, AZ. I am Looking for alternative methods to track time as student’s progress through our courses. I am not looking for a time management system, just a tool to enter a student’s hours into a spreadsheet or software to help me manage…
-
Round Up
I have a calculation for Total Hours that takes the DURATION (set to days) multiplied by UTILIZATION percent, then translates to hours by multiplying by 8 hrs. I want the result to always be a whole number: "round up" to the next whole number if the decimal is greater .25, otherwise round down. Currently, the formula in…
-
Printing cell history value
I have A1 and B1 which are two different dates (for illustration: A1 is today's date, and the other in the following day). I have data value in Cell C that is changed daily by another cell linking formula from other sheet. Then I have cell A2 and B2 -- the formula in these cells is: =IF(today()=ColumnA1,CellC) and…
-
SUMIF across a range
Hi All, I'm trying to use SUMIF to sum the total of all rows that meet a specific criteria * =SUMIF([SERVICE TYPE]:[SERVICE TYPE], "Monthly Charge", [2017-12]:[2018-01]) This however returns #INCORRECT ARGUMENT. Not sure what I am doing wrong. Any suggestions would be most appreciated. Regards Colin
-
How do I - formula ques
I have a formula =COUNTIF(Age8, >65) which is working, but I want it to only give me a count if a certain checkbox field is checked. Is there a formula for this?
-
SUMIFS Formula Needed for Multiple Calculations Summing from the Same Column
I am working on a budget sheet, and need to be able to calculate OPEX expenses per site, and CAPEX expenses per site. I've got 6 different sites, and need these totals for each quarter. The formula below seems to work, but I can't use it more than once within the same column without getting a circular reference error. This…
-
Turnaround time for the month of...
I have a sheet with thousands of projects. When a project is finished there is a cell that automatically calculates the turnaround time. There is also a column for the date the project was finished. The projects are not ordered by date. On another sheet I need to calculate the average turnaround time for a given month for…
-
Count Ifs Formulas
I need help figuring out why this formula is returning Invalid Data Type: =COUNTIFS([Conversion Status]:[Conversion Status], "Won", [Date Requested]:[Date Requested], MONTH(@cell) <= "3", [Year]:[Year], "2017") I want to count the number of lines that have a Conversion Status of "Won" that also took place in March of 2017
-
Form get value as tekst from som users
I got a form and the value is present as text some on some users and as number on others. Why is that ? The calculations get wrong withe the texts. Regards Jonathan
-
Counting Occurence of String of Text in a Column
Hi, I need suggestions on how to count string of text on a column. For example, i need to count how may GRC are there on the sample below: GRC Aer, GRC Aer, CDIR, GRC HTM etc. etc. Thank you!