blank cells excel

I have a table counting results from football games and am currently using =IF(D45=H45,"T",IF(D45>H45,"W","L")) to determine the result. (which works well) The problem i am having is that the sum counts the blank cells as a T. Any and all help is greatly appreciated

Hi Gurus, Can you share your idea on how to automate this? I have below data usually long set. Account Country Score Date 1 France 1000 09/30/2021 2 Norway 500 05/31/2019 I wanted to separate and add 2 blank cells if the date is more than 1 year. Let's say macro will ask for...

Hi All, I am having problems figuring out a formula that would give me the total days used. I have the working days in a month using the networking formula ( I need to include holidays). I need to have the total of Days Used (column 5) including blank cells by subtracting the Date Out (column...

Hi Guys, Bit of a newbie here. I'm working on a very large set of data. Each column contains over 20000 values and I've got a bit of a dilemma. I'm trying to create a macro that can find any values between 0.0401 and 0 AND any values between -0.036 and 0 and clear the contents as well as...

Hello to everyone on this forum! I am so glad I found this because I am pretty stuck. Here is my problem: I have a list of names on one excel sheet, I have a formula that takes whatever name is typed into a particular cell and checks the number of times that particular cell appears across a...

PROJECT DESCRIPTION: I am making a time sheet. Rows 32 and above list the hours I have worked in a day. Each row represents a day. Each column represents a different castigatory (vacation time, hours, overtime, sick time, etc.). Row 34 lists the $ I earn for each category. I am using column M to...

I have a problem with data I downloaded from a government website. There are cells with numbers which I was able to convert to numbers from text but there are some cells which are blank and I want a 0 in all the blank cells. Excel doesnt consider the blank cells to be blank but treats them as...