sumif and condition

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 Lovelies! I have a formula that counts how many times a weekday occurs within a set range (Trial1 (B8:B107)), now I am trying to add an additional condition. I want to count the weekday but only if the correlating cell in "column E" is not blank ("<>"). See below for visuals :) Thanks a...

I have an excel where I need to pull in the total hours for a date range (always start on Monday) in my excel tab called 'Dashboard'. I'll be getting the data from the tab 'Budget' but I only want to pull in the number based on the QuickBooks Code I've identified on B1. So AH3 will equal to...

Hi, I have a list of codes (column A), and amounts of money (Column B). I would like to sum all of the codes but where the codes are the same, only have the sum for the first instance of that code from the list. eg see the example below TIA CODE AMOUNT RESULT CAT 5 11 DOG 6 16...

Hi all.. I need to pull in some data across sheets and having a hard time.. Essentially I'm working on two data sheets. For sheet 2, I want to pull in a number from sheet 1 if it meets 2 criteria, A) if the name matches say cell A1 and B) if the colour matches O1, then for it to look into...

Hi I want a formula that will sum data in a range based on a set criteria and I’m struggling. I have 1 - 100 data sets that I want to total 3 different columns with. Currently my formula reads = sumif(acc!$d$4:$ec$4,’FWD’,acc!$d5:$ec5) and that’s working to give me the total for all 100 data...

Hi I apologise in advance if this is not clear but I’ve tried to refine my thoughts. In this link is a modified (smaller) version of a file I’m working on - Help Please.xlsx I have a page called explanation trying to highlight what I am wanting to achieve but I will go over it here as well...

Dear beast regards I am working with some figures on the number of people in a country, classified according to sex. I want to carry out sums taking into account specific age groups, for example Men between 2 and 10 years old (Men_2 - Men 10)...

Hello, Is there a way to have a formula get the total for x columns? For example the first row for Company 2 would be the total of ($10*100%) + ($10 *100%) +(10%*50%) vs company 3 which would be the total of ($20*100%) + ($20*50%). The tricky part is that company 2 on the next row could have 4...

Hi All, May you help me with below? Name in Column "H" will be the lookup value vs "A" and "D". Other condition is in the table:

Hi there, I am trying to format data for a project that has thousands of clients that are each billed separately for each product every month. What I am trying to do is make it so that column D shows the total billed (Column B) for client (Column A) during the month/year but only in the row...

Hi, if it helps, i've uploaded my file to dropbox: Dropbox file I have a workbook with two sheets. one called "2020", which is the main sheet and the other called "Data", where i'm basically just aggregating data. the purpose of this file is to essentially keep track of my finances...

Hi! I have been struggling for 5 days trying to get this formula to work. Basically, I need it to search across a few worksheets which I have named "JON" and sum a corresponding cell if it meets two conditions. The formula returns a "Value" error...

I've made myself a budgeting spreadsheet to keep track of my finances. Now I'm in the process of putting some functions/ formulas to make it easier to use but am having difficulty with SUMIF function. My budget spreadsheet consists of a calendar type budgeting system where each month has it's on...

I am using the following SUMIF formula in my spreadsheet: =SUMIF('2020 CBAT Schedule'!$J:$J,!$A2,'2020 CBAT Schedule'!AX:AX) When I attempt to drag the formula down it displays zeros instead of hours from the corresponding tabfrom which it should be sourcing the information from. The same...

Morning, I have a list of monetary values that are associated to reference numbers. What formula can I use in order to sum up the monetary values of the reference numbers if they are the same reference numbers. For example Ref: #123 Value: £100 #123 £200 #124...

I can't determine whether to use COUNTIF, COUNTIFS, SUMIF, or SUMIFS in this situation. I've tried all four and none do what I want so I'm seeking guidance here. I'm trying to total items in a column only if the date in the adjacent column is between two dates. Column K is DATE (every day of...

Hello all, I am working on creating formulas for a summary sheet and found a link to code that build permuations and its on the right track but I am not saavy enough to modify it. Here is the explanation. I have 2 columns, Column G is a for Prior Period, Column I is for Current. There is...

I've been racking my brain all day on this one and desperately need someone to swoop in and give me the answer. Data is set up as follows: <tbody> SSN $Dollars Date 123 $10 10/10/2018 123 $10 10/12/2018 456 10/14/2018 456 $20 10/16/2018 123 11/10/2018 789 $10 11/12/2018 1011...

I currently have a set of data as follows: <tbody> Jan-18 Feb-18 Mar-18 Apr-18 Jun-18 Jul-18 A 1 2 3 4 5 6 B 7 8 9 10 11 12 C 13 14 15 16 17 18 D 19 20 21 22 23 24 </tbody> I have a dynamic lookup value for the date and want to be able to sum the values that are less than or equal...