sumproduct ; -- ; countif

I am trying to sum up the number of people working in a specific time interval and day.. But I cannot seem to get my formula to work. Column A = Name (Manual input) Column B:H is days they are working (Manual input) Column I:J Start/End times (Manual input) I need formula in Columns M:U...

Hi, I have below data..and need sumproduct in such a way that if RM PO price is greater than 0 sumproduct must include plan inward * RM PO Price and if RM PO price is less than 0 sumproduct must include plan inward * FG PO Price in below data sumproduct calc should - sumof (...

Hi All, I have a workbook where I need one countif formula to incroporate multiple cells for one section. I have used adding the countifs together but it makes me workbook run super slowly. I know there is a way of using some products for the same thing but dont know how to actually do it...

I'm trying to calculate a simple AVERAGE based on two source tabs 'Category' and 'Score'. Stipulations: 1) No helper columns on the source tabs; data from source tabs are exports from other systems that must remain untouched 2) Average scores on 'Result' tab should be calculated using a formula...

Hello loverly people, kindly help me with a formula that can return orders waiting to be fulfilled from the sales sheet into the stockinventory sheet And a formula that returns the stock qty waiting to be received in the stockinventory sheet from the pur sheet and then i also want to be able...

Hi all, Thanks for any help you can give. I have a spreadsheet of data, that has a number of columns which represent various stages of a process from entry date to completion date and stages in between. I am looking to calculate an average between various stages in the process, by months so I...

Hello, I have a great SUMIFS formula that pulls from a drop down menu. I have multiple criteria and conditions well established, however if the criteria selection is "ALL" from the drop down list, I'd like to sum all those totals based on the other criteria selected. A. Joe's Totals B. Barb's...

I was having trouble with COUNTIF, so I fell upon this old thread: http://www.mrexcel.com/forum/excel-questions/84490-countif-not-counting-all-values.html In the third reply, fairwinds suggests using "=SUMPRODUCT(--(A1:A10={"y","n","n/a"}))" instead of COUNTIF. For reasons I don't know, using...