• Home
  • Excel Formulas
  • Excel Functions
  • Excel VBA
  • Help us Answer Questions
  • Ask a Question
Home / Posts tagged cells

How to sum cells while ignoring ones with text in the same sum?

Hi there! Currently working on something that adds hours up over 4 weeks to sum the total hours worked in a month. However, I cannot allow the spreadsheet to …

July 25, 2018 | Excel 2003 Help, Excel 2007 Help | 0 Comments

Enter a letter code in one cell and represented number in another cell

I will do my best to explain what I’m looking for – I hope it makes sense! I have included a bit of my worksheet so you can hopefully understand …

July 13, 2018 | Excel 2003 Help, Functions | 1 Comment

Joining the text of two adjacent cells.

As stated in the title my question is how to join the text of two adjacent cells. For exaple if cell A1 says “happy” in it and cell B1 says …

July 11, 2018 | Excel 2003 Help, Excel 2010 Help | 0 Comments

Excel Sheets From A List

I would like to know if it is possible to automatically create sheets from a list of cells. Example –   Excel List: [Apple] [Banana] [Carrot]   …

August 21, 2017 | Excel 2003 Help | 0 Comments

HELP / Macro

Hi im new to excel, cut a long story short i want to make to make a button so that every time i click it, it makes a shape, in this case the shape is a simple …

May 6, 2017 | Excel 2003 Help, Macros | 0 Comments

Topic Groupings

AND Array chart Colours in Excel Conditional Formatting count countif COUNTIF Function data Date Dates & Times Excel Excel-Vba Excel 2010 Excel Formula Excel Formulas Excel Functions Excel VBA Code find formula formulas function graph help IF IF Function index list London LOOKUP Macro Macros. match percentage Pivot Pivot Table search SUM Sum Function SumIf SUMIFS table time VBA vlookup

All Time Popular Posts

  • Excel Formula Based on Cell Background Colour 120,427 views
  • How to Concatenate in Excel using LEFT, MID and RIGHT String Functions 85,348 views
  • IF Formula if Time is Greater than 10am 64,028 views
  • Automatically Run Macro when Cell Changes 63,677 views
  • Get File Name with Excel VBA 52,375 views
  • If Functions 52,119 views
  • Add Command Button to an Excel Worksheet 47,917 views
  • Calculate VAT in Excel 43,468 views
  • If Function – If False Do Nothing 38,307 views
  • Excel 2003 Color Scheme when Downloading from SAP 35,425 views

Popular Posts Last Seven Days

  • IF Formula if Time is Greater than 10am 333 views
  • How to Concatenate in Excel using LEFT, MID and RIGHT String Functions 184 views
  • Automatically Run Macro when Cell Changes 174 views
  • Excel Formula Based on Cell Background Colour 142 views
  • Go to Next Blank Row in Excel 127 views
  • Get File Name with Excel VBA 96 views
  • Add Command Button to an Excel Worksheet 72 views
  • How to Check if an Array is Empty in Excel VBA 63 views
  • copy cell data between sheets based on criteria 62 views
  • Enter a Formula to Compute Total Cost 54 views

Pages

  • All Excel Help Posts
  • All Posts
  • Ask a Question
  • Contact
  • Home 8
  • Latest Questions on Excel Geek
  • Post Archive

Categories

  • Excel 2003 Help
  • Excel 2007 Help
  • Excel 2010 Help
  • Excel Formulas
  • Excel Geek
  • Excel VBA
  • Excel VBA Books
  • Favourite
  • Formula
  • Functions
  • Keyboard Shortcut
  • Macros
  • Spreadsheets

Recent Posts

  • VBA to loop through a folder of word documents and populate with data
  • Client Ledger Problem
  • Sheet name reference from dynamic cell
  • Concatenate/IF/SUBSTITUTE/LEN
  • Locking cells to rows
© 2014 ExcelGeek. All rights reserved.
Optional footer notes.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close