sumif and countif

  1. H

    COUNTIF function for filtered tables

    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...
  2. J

    Counting unique text values based on month

    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...
  3. D

    Counting Unique Values If Value in Another Column is True

    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...
  4. C

    Counting Frequency of Numbers in a Column

    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...
  5. B

    Sumif for a certain format

    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...
  6. F

    Sum Based on Multiple Criteria

    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...
  7. J

    Problem with sumif & countif functions

    <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...
  8. J

    COUNTIFS/ SUMIF only visible cells

    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
  9. J

    VLOOKUP + SUM or SUMIF?

    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)...
  10. F

    VBA - Count if type function

    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...
  11. M

    Sum of values in a column if text in the same row of adjacent column matches

    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...
  12. M

    Sumifs i guess

    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...
  13. Y

    Counting distinct values based on two criteria one of which should be a range

    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...
  14. S

    Sum a certain amount of cells based on 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...
  15. Y

    Count

    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...
  16. T

    SumIF? or Am I Just DumbIF?

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

    Indicating where a range has overtime hours in a range of cells

    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...
  18. M

    Sum based on Multiple Criteria in separate sheet

    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...
  19. M

    SUMIF very slow - Excel 2008 for Mac

    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...
  20. B

    SUMIF query

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top