sumif and condition

Hello everyone, I am currently working with a large amount of data from an output. I am trying to make a formula that only counts one instance of a repeated value. Basically, and I am trying to make a head count based upon name and rank and I am getting repeated information throwing my count...

I would like to calculate the total hours for M, T, W, Th, F, Sa, Su Can you please help with the formula? I was able to get the total hours for each employee but haven't been able to figure out how to break it down per day. I have the following table: <tbody> Employee Name Employee Number...

Hello All, I love this forum learned a lot from here. I am stuck on a problem and was wondering if anyone can help. I have a table with 2 criteria that i am using a sumifs formula. I've also created another " zero check" column in the table to read 0 if row needs to be omitted and ""false" if...

You probably read this title and thought "=sumif, dummy". However this dummy can't seem to get it to work nicely in this case. Would love some assistance. To the issue: First off, I know I could do this via VBA, but I would love to be able to accomplish it with simple formulas if possible. I...

Hi Everyone - I'm looking to create a sum formula to capture multiple criteria and I am open for suggestions. <tbody> Jan Feb Mar List: List: Car 1 1 2 Car Jan House 2 2 1 Airplane Mar Airplane 2 3 3 Boat Boat 5 5 3 Formula: XXXX </tbody>...

I am hoping you can provide assistance. I have a worksheet with various account numbers spanning several hundred rows. Although the numbers here are in sequence the accounts could vary 10045, 20048, 81007. What I would like to have happen is to have excel total the sum of a column if the...

Hello guys, I need a help create a sum with 1 condition in multiple columns. Here's an example: <tbody> Quantity 1 Quantity 2 Quantity 3 Quantity 4 Item 1 -1 0 1 2 Item 2 0 -1 1 2 Item 3 -2 1 -1 2 Item 4 0 1 1 -2 </tbody> What i'm trying to do here, i want the sum to be separated...

Hi All, Probably the hardest thing I've had to do in excel and I need someone with a better skill set than I currently have please! I've put together a pretty big spreadsheet which draws data from ODBC links to a database. Part of the report shows how much has gone out over 12, 6, and 3...

I'll C&P a small amount of the data below, but this is what I am trying to do. In column A there is a number between 1.002 and 1.900 which are grouped together. Then in column B there is a 1 or a zero (completely binary). I want to Sum all the groups' B columns. So for example, I have 16...

Hi My dataset is similar to below I would like to sum the values in column D, for example, based on a chosen date in cell E1. So if E1 = 22/10/2017 then E2 would = 7 Many thanks <tbody> A B C D 1 06/10/2017 29/10/2017 22/10/2017 2 BA 8 7 4 3 BA2 4 1 1 4 BA3 2 3 2 </tbody>

TOTALSUM AS PER MONTH & YEAR WHEN STATUS CHANGES TO CASH OR DEPOSIT =SUM(SUMIF(B6:R6:B11:R11:B16:R16,{"Deposit","Cash"},B3:R3:B8:R8:B13:R13)) ====THIS IS MY FORMULA WORKING FOR ALL the cell total whenever the status is cash or deposit but I want to do this formula with one more criteria as...