sumif and countif

Dear Madame /Sir I am using an excel sheet where I am applying auto filters using VBA. In Column 6 , I have type of training (eLearning, InClass, Webex) and in column 7, I have time required for the training. After applying filter I am able to see how many hours of training required for...

I'm exporting data from Salesforce monthly in order to summarise our sales pipeline. The data come out as: <tbody> Account Name (A) Contract end date (C) Company A 20/05/2016 Company D 23/11/2015 Company C 17/09/2015 Company A 31/01/2018 Company B 31/01/2018 Company B 03/05/2018...

I'm trying to find the sum of unique values in column A but only if the corresponding value in column C is 'true'. Right now I can find the number of unique values in column A but can't seem to figure out how to make it only count certain cells. I have...

I'm trying to count the number of values that fall between a range. I would post a picture, but I'm not on my computer with Excel (sorry!!!). But, for example, I would like to get the Frequency column from the Data to count column: <tbody> A B C D E 1 Data to count Range Frequency 2 1...

How do I add up values in a particular format and ignore values in other format. So say I have a row with values of dollars($) and sterling(£) but I only want to know the total of the dollars at the bottom of the row and ignore the sterling (£). Also say I have a row with percentages(%) and...

First time posting... What I'm trying to do: I have a drop down box with 4 airplane tail numbers listed (Cell A). The cell next to it also has a drop down box with the prices (Cell B). (Cell C) I manually input the variable. (Cell E ) gives me my total. Cell A (Dropdown) N23241...

<tbody> Round Date Fixture Team Formation Scored 1 9/13/2013 TEAM A v TEAM B TEAM A 4-4-2 3 1 9/13/2013 TEAM A v TEAM B TEAM B 4-4-2 0 2 10/01/2013 TEAM A v TEAM C TEAM A 4-4-2 1 2 10/01/2013 TEAM A v TEAM C TEAM C 3-5-2 1 3 10/08/2013 TEAM D v TEAM A TEAM D 3-4-3 2 3 10/08/2013 TEAM...

Hi I'm wandering if anyone can help me. Im looking for a formula where I can apply COUNTIFS and SUMIF functions to only visible cells. The SUBTOTAL function will not do in this case. Any help with this issue would be greatly appreciated. Thanks

I have 3 lists each with 2 columns. Within the 2nd column of each are values I need to be added together. The keys within each lists' left column are mostly matching, however each list has its own variation (ex. on might have a unique key within their left column, different than the others)...

Hello everyone, I am in need of some help with a count if type statement but I do not think countif will do what I need and I am not familiar with the VBA coding in excel. Currently I have two different workbooks that are wanting to be combined and can be by adding in one column that...

I need to sum values in a column, but only if the text in the same row of the adjacent column meets certain criteria. Below is a simplified version as an example: A1 - Apple A2 - Banana A3 - Apple A4 - Banana B1 - 3 B2 - 2 B3 - 1 B4 - 1 I need a formula that will add up the cells in column...

Im trying sum values of a certain category for a whole month. Im trying sum if but does not work <tbody> NOV 1 2013 NOV 2 2013 Nov 3 2013 Nov 30 2013 Page Brand Name Category Size Revenue Rev on Ds Brand Name Category Size Revenue Rev on DS Brand Name Category size Revenue Rev on...

Hey everybody, I already managed to almost solve my problem with putting together a rather long formula from existing threads but when it comes to those ranges I give up. I have a very large data set (30k rows, no blanks) and I am trying to count distinct account numbers based on two criteria...

<o:p>Hey everyone! So I am having some issues creating a formula that will add (sum) the first 30 cells, if they meet the criteria, and then stop after 30 cells, that have meet the criteria, have been added (summed). This is what I am trying to do; I am currently working on a daily production...

I am trying to count how how many times the value in column B is greater than column A. Any help appreciated <tbody> ColumnA Column B 126.83 0 1805.89 0 1805.89 0 542.29 538.04 1711.52 1712.24 2546.59 0 686.65 706.38 683.52 696.06 836.33 0...

If D1 = YES, then B1 = A1 +1. I don't know how to write this easy formula. Assistance is appreciated.

Hi there Hoping you can help. I'm a newbie to this forum, hope below makes sense In summary I have a spreadsheet where I log technician hours as well as holidays and sick days I have the date and day of the week in AA1, AA2 (entered as WEEKDAY(AA1,1) and AA3 is where I log the hours worked...

Good day all, I'm currently struggling with this conundrum...I need to transfer a figure from the end of a Row based on two criteria, column J= "1" & column O="Manufacturing, all this info being in a separate sheet, so far I have two formula's...both returning an incorrect result...

Hello All, I am brand new here, but have gotten great advice here for years! I was hoping that you could tell me if there is something wrong with my machine or the way that I am going about my calculations. First, I run Excel 2008 for Mac...my iMac is a 2.66 Ghz Intel and 4G memory. So, VBA...

Hello all, I'm having a problem getting a formula for my following problem: <TABLE style="WIDTH: 199pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=264 border=0 x:str><COLGROUP><COL style="WIDTH: 18pt; mso-width-source: userset; mso-width-alt: 877" width=24><COL style="WIDTH...