sumif & offset

Hi Everyone, I have table with 4 column A, B, C, D: Data sample: text A Pre-condition testB1 OK testB2 N/Y testB3 NG text B testB1 OK testB2 OK testB3 OK testB4 OK testB5 OK text C testB1 OK testB4 N/Y testB5 OK I want to fill...

Hello All, I have noticed that this has been a question in other threads on this forum; however I have been unable to locate this particular question using the formulas in the sheet below (vertically vs horizontally). Question: Is it possible to make a dynamic XIRR formula to search for the...

So it's a little complicated what I need. Therefore bare with me :). I need to find a date which will be taken from a sheet called Raport. Cell where data validation of the date is "D4". I need that date to be searched in multiple sheets. Each sheet is showing like this...

Hi, Hope someone can really help me as I have been struggling and not getting any where with this and my current solution is going to take me days to complete. I have a cashflow for a number of projects, and each project has 7 different types of cashflow all going horizontal. However, as we...

Hi folks, After success on this board earlier this week, I’ve decided to put together a management information type system for my department at school. I currently teach at different sites and I’m trying to ensure an even split of equipment between sites. I’ve put a simple site, course and...

Hello I need help summing data in a column if the range of columns falls on a certain day. See below for an example of my Gantt spreadsheet. It is divided into 8 hour days. The jobs are on the left side "Y" axis and their progress is depicted in each row. To the right of the job are the...

Hi, I want to sum rows using the match function. I need the match function to figure out what row to sum based on the value in column A then skip 2 columns and sum row X columns D-F. Any ideas? Below is an example. Column A Column B Column C Column D Column E Column F Row 1 # Street...

Hello - I'm hoping for some help on two formulas/use cases I can't seem to figure out. Unfortunately, I couldn't quite figure out how to attach the date set but have included here with reference rows/columns for what I hope is an easier explanation: Q1: I would like to populate cells based on...