sumproduct formula

Hi All, Please assist me on below table so that formula can calculate counts of 'Yes' between 2 "Total" between different months. Please review below table for the reference. Formula auto calculate Mar month 'Yes' for different persons for that month only. Similarly for Apr and May month. Any...

Hello community. I'm sending attached the file that's an adaptation of a free template that i found online. During my adaptations i came across with a problem that i can't solve: In the attachment you're allowed to see the formulas apllied to "NJ" and "NK" cells, where in the formula bar the...

Im trying to write a formula into a cell, which will later be copied down its column but Im struggling with understanding how to write the formula in vba so it is suitable to be copied down. The formula will be written to the right of a set of data which has a variable number of columns but...

Hi all, I'm curious to see if anyone's got any bright ideas about how to simply a sum formula I've created. I'm trying to sum figures in the range of columns O:R on a WS named 'Daily', where the only rows considered are text values from the range B6:B12 that are also in column D on the Daily...

Hi all, I am currently working on a turnover report and i am having some problems using the countif formula to count e.g. the number of staff resigning on a certain month with a certain title. <tbody> A B 1 Title Last day of work 2 Sales Associate 25-Jan-15 3 Sales Associate 16-Apr-15...

I'm trying to write a formula to calculate the average investment size weighted by the total dollars we've invested and need to be able to separate out investments we've made through fund 1 and fund 2. I thought it would look something like this: =SUMPRODUCT(--(Cell Range ="Fund 1"),(Cell...

I have a massive excel spreadsheet of data that contains thousands of URLS and web performance data. My table structure is: Col B = Microsite Col I = URLs Col S = Total Page Views I am trying get extract the total in range S3:S1048576 where the values in range B3:B1048576 = "xyz", and the...

Hello, I am trying to create a summary file that will be used daily for multiple plant summary files. I want to access the shared public drive, which stores the output files in CSV format. 1) Files are dated and stored in a CSV file, daily, for each plant 2) Date format would be...

I am so close but yet so far away.... ok- A B C D E F <colgroup><col><col><col><col span="2"><col></colgroup><tbody>...

Hello All, Thank you for your time. I am in need of your assistance in finding a better way, a more efficient non-vba way, of getting the results I get from nesting Ifs. I currently pull data from our main frame and do a visual scan. I developed a crude If statement...

Hi there I have the following formula on sheet1 =SUMPRODUCT((Mariska!H3:H36>=Sheet1!C1)*(Mariska!H3:H36<=Sheet1!E1)*Mariska!L3:L59) What i am trying to do is to sum column L on the sheet named Mariska if the date in column H (sheet mariska) is >= date in C1(sheet1) and <= E1. with the current...

I'm trying to copy a SUMPRODUCT formula to other cells, but I have different array lengths. Is this possible or will have to continue to copy and paste the formula to the new cell and manually adjust the arrays? Is there a way Excel can find the breaks/array length difference? Thanks, RJ

Hello, I have the following two columns in A1:B4 (customer # followed by percentage) 1 0.5 2 0.9 3 0.8 4 #DIV/0! In column D i have a list of the customer #s. In column E i try to identify if the customer in column D have a percentage >=.8. I am using the below formula, but...

I created a form where by using a COUNT:=SUMPRODUCT((TEXT(Order!A2:A65535,"m/dd/yy")=TEXT('Order Confirmation'!$J$34,"m/dd/yy"))*(((Order!J2:J65535>=1)+(Order!I2:I65535>=1))>0)*(Order!A2:A65535<>"")*(Order!J2:J65535<>"")*(Order!I2:I65535<>""))...

Hello to everyone on this forum! I am so glad I found this because I am pretty stuck. Here is my problem: I have a list of names on one excel sheet, I have a formula that takes whatever name is typed into a particular cell and checks the number of times that particular cell appears across a...

Hello, I have a formula that excludes certain text in cells, and counts everything else- but I want it in addition to counting the cells that exclude the text, sum up the costs in the next column. So far I have this which works in counting all the cells that DO NOT contain the texts...

Good Day I have been given a task to create a register for another department within our company. My original register was setup with the help of all the wonderful people on Mr Excel. The new register I have to create is pretty much the same, however the formula I used before checked for 2...

hi all my new at this. I am having a problem with an sumproduct iam trying to find out how may Saturday a list of dates. Sunday to Friday are working fine with is =SUMPRODUCT(--(WEEKDAY(A4:A300)=1)) for Sunday =SUMPRODUCT(--(WEEKDAY(A4:A300)=2) for Monday =SUMPRODUCT(--(WEEKDAY(A4:A300)=3)) for...