googlesheets

Hi there! I'm trying to figure out a way to sum a row based on two cells in the same row. I tried to use a sumproduct but I'm getting an error as I have text in my sum range. Any way to ignore the text to just sum the numbers? Maybe sumproduct isn't even the best way to go about this? I'm...

Hi Please tell me this isn't possible if so. I have a google sheets that has check boxes (D3) which require a date in cell next to it (E3) and I would like to take out formatting issues by using a formula to input the date I have managed to get =if(D5=true,TODAY(), "") to work but this just...

silly question I have a spreadsheet that I have been told to put on to google drive. I have found an issue where one person has sorted a column (ie click on the C at the top and sort into alphabetical) instead of filtering. does anyone know if you can lock a sheet so users cannot sort but...

Hey all, I'm trying to find a formula that will help me with a project I'm doing. Im creating a meeting attendance record and am using checkboxes to check the person in the meeting. At the bottom of the sheet if they are supposed to be in a total of 5 meetings this month and only come to 3. I...

Sub RectangleRoundedCorners2_Click() Dim myRow As ListRow Dim cell As Range, DataEntry As Range Dim i As Long Sheets("Sales MTD").Unprotect Password:="password" With ThisWorkbook.Worksheets("Sales MTD").ListObjects("Submitted_Sales") Set myRow =...

I've been spinning my wheels on this one for a while now and I am ready to tag in a friend... Referencing the attached image, I am trying to: Count the number of occupied cells in D2:H Based on the strings present in columns A-C Using criteria from another sheet (represented here in J4:K8) So...

I have a column that has 34 records of Week Day, Month/Day, and Times. I am looking for two formulas or a script that I can use in a table that will give me the count of weekdays and the time duration per day. Eventually, I would like to just copy and past new dates into column A and have the...

Hello, I've created a table for warehouse inventory and I wish to automate this as much as possible using google sheets. Column A: Manual input of the material (with specific info) Column B: Material Type (This is from a drop down menu created in sheet 2 - the material type is fixe only 10...