sumif

Hi, I am looking for a formula to put in cells B2:F7 on Sheet 2. Notes - This is a simplified version of the file I am actually working with. The file I am working with has all work-day dates (Mon-Fri) in row 2 on Sheet 1, for 01/01/2021 to 30/06/2022. - Each Trade Reference is unique, so...

Sum units is expected result - there are over 2000 lines and i need to sum all per row with heading of "units" Sub GPSUM() Columns("k:k").Select Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove Range("k5").Select ActiveCell.FormulaR1C1 =...

Hello, I have in excess of 30 identically formulated worksheets that contain (amongst much other information) lists of stock, location and quantities in different columns. I want to create a single summary page that searches through all the worksheets between a Blank Start worksheet and a Blank...

Hi all, i want to sum only numbers contain 15 in range. all data are in number format. Example is attached. Thank you very much in advance.

Hi, I have an issue with a colleague of mine. I have created a report for her which works fine on my laptop (Windows 10), and also my other colleagues laptop (also windows 10) however when I send it to her (Windows 7) she gets a #name? error in some of the SUMIF fields, however a majority of...

I am new to spreadsheets and have no training. My knowledge is very limited. Screenshots of the spreadsheet I’m creating are attached. I am attempting to total all miles and fuel by state on sheet “Quarterly IFTA Report” for all the sheets between the sheets “Start” and “Stop” Additional sheets...

Hey guys, I have looked online and have found some similar questions related to this, but nothing I have found seems to work. I am trying to use a SUMIF statement on a large collection of data. For the most part, it works just fine. However, if there ever happens to be a blank cell in the...

I know using SUMIF would work if I selected the cells with the ":" such as: G7:G106. However, I only want to sum multiple (specific) cells if they are more than X. If, for example, I want to exclude G7 because the number is negative and only sum the other cells, I run into a problem. Here's an...

I have made a formula which corresponds to certain components. I need to make this formula for each day of the year for 9 components, using information from another worksheet in the file. However the cell range is from e.g. 1:23 for the second day it is 24:47, so forth. I cannot drag this...

Hi, Looking for help to calculate the number of instances wherein a assigned limit has been utilitzed greater than or equal to 90%. ColA having Date ColB having Individual names ColC having limit utilization in %age and ColD having Instances (the desired output). Case: If individual (Tom)...

So I have date in the format Value Start Date End Date 40 14/10/20 05/11/20 50 01/10/20 31/10/20 Assuming the value can be spread evenly over days, I want a sumif function that tells gives the following output (ie for Oct, 17 days of the 22 days of 40, PLUS 31 days of the 31 days of...

Hello I've been applying a solution posted by Rijnsent to take sales data of finished products and populate a raw materials inventory table. Here is the solution posted by Rijnsent: - https://www.mrexcel.com/board/threads/raw-material-stock-management-using-excel-help.1084422/ Sales of...

Hi, I am possibly using the completely wrong formula or it is not possible to do what I want. Basically I am trying to Sumif the number based on the month, so for example the month of October I am expecting the number of 75 but am only getting 15, as the formula is just adding row 3 column C:E...

im confused as to how i should create a formula to get me a sum of a dynamic range based on a value present in both my tables i ve been trying to reference the relevant table columns as range and criteria but im screwing something up. specifically for the example i need the sums of "Rent Soll"...

Hi! i am very beginner in excel i dont know many things :D i have this formula =SUMIF(N12:N4997,"oikistiko",G12:G4998) it works good but when i filter an other cell it counts all the cells with oikistiko inside i want to have results only the cells i see after filters with search i find...

I did a precursory search, but couldn't seem to find anything that would help. I'm trying to write a =sumif formula into the green colored cells, based on numbers entered into the orange colored cells, determining from a list of colors in the drop down menu at the right of each of the orange...

Hi All, I'm trying to solve the following problem using some combination of sumproduct, sumif, and countif functions: I have a dataset where people move into and out of areas at different times. Sometimes there are multiple people in an area at a time, other times there are none. Each area has...

Hi All, I'm trying to add quantities values of a table depending of the category reference and costumer (on this case "A"), but I cant figure it out why I have and error on my formula (#Value!). Category Costumer Qty 1 A 70,700 5 B - 3 A 21,000 3 C 12,136 5 B 6,560 1...

So, I'm about to loose it with this one... :) I've sketched a file in my work pc (MS Professional Plus 2016) and when I open it in my mac (MS Excel for Mac 16.41) a formula is not returning the same value. In fact it returns "0". Maybe this is simple, but I don't quite understand what to do...

This is an hourly results table which can be extended quite far to the right, I want to add the values which correspond to all instances of each code (A,B,C etc), so in the table below "A" would be 1050 (100+100+200+250+100+300). The codes are listed in a table elsewhere and the total will be...