countif; sumproduct

This Week's Hot Topics

• Help with summation of different rows in 1 column

  • Started by bassemjohn1
  • Friday at 9:47 AM
  • Replies: 30

  [B]Hello guys, [/B] I am new here and am in need of your help,I have a report that is really taking a huge time and all I need is a [B]way to sum...
• Excel VBA Code to Compare Rows in Two Different Sheets and Highlight Only the Cells that are different/unique

  • Started by Walkerwood9
  • Jun 23, 2020
  • Replies: 25

  I have a workbook that has two sheets in it and I want to compare these sheets (Test1 and Test 2) and highlight only the individual cells that are...
• COUNTIFS function help please

  • Started by andrewmurray86
  • Jun 23, 2020
  • Replies: 25

  Hi all, This is my first post here: I'm attempting to identify the smallest number within a column. I have a series of sheets with a column...
• Move row automatically to the bottom of the sheet when cell changes

  • Started by CindyLou
  • Jun 23, 2020
  • Replies: 23

  I have a column of "Open" and "Closed" items. When the cell is changed to "Closed," I'm trying to get the whole row to go to the bottom of the...
• Change date format on import

  • Started by namloop
  • Jun 24, 2020
  • Replies: 37

  Good morning I am importing some data and I am having two different issues in col. B. In rows 3 this data says Nov-9 (the 9th of November) when I...
• Problem with macro

  • Started by Jeeremy7
  • Jun 24, 2020
  • Replies: 20

  Hello, I have a macro running but i think some informations are in double so the macro doesn't work.. If somoene could help it would be really...