Hi all, need help regarding how to make a formula ignore blank cells. I have formulas within a worksheet that looks at the values contained within a row of cells and then compares them with the values in the next row. There are 3 formulas, the first looks to see if the values in the upper row are larger, the second looks for larger values in the lower row and the third looks for matching values. The following shows how i am employing these in my worksheet, basically i'm analysing football results and the formulas give me a breakdown of games won, lost and drawn. The trouble i'm having is that the third formula that looks for matches is comparing blank cells with blank cells and so is distorting my results. How do i get it to ignore blank cells. I've searched through the message boards but after reading through them i'm not sure whether to use Isblank or Isnumber or whatever.
Any help will be greatly appreciated.
An example of my worksheet, the data being analysed is row C5:U5 compared with C6:U6
This is where the formulas are, all are fine if the data range contains data in every cell. However, when i clear the contents to input new data my formula for counting draws, cell AM5, is counting blanks. Not what i want.
Hope i've made things clear, thanks in advance.
What happens when there is no data, Cell AM5 shows 19 draws. Not what i want.
Any help will be greatly appreciated.
An example of my worksheet, the data being analysed is row C5:U5 compared with C6:U6
Footy Tables Rev2a.xls | |||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | |||
5 | Arsenal | H | 2 | 0 | 1 | 2 | 2 | 2 | 2 | 0 | 5 | 2 | 4 | 2 | 1 | 4 | 3 | 1 | 2 | 2 | 3 | ||
6 | A | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 2 | 1 | 1 | 1 | 2 | 1 | 0 | 1 | 0 | |||
7 | AstonVilla | H | 0 | 2 | 0 | 1 | 2 | 3 | 0 | 3 | 2 | 3 | 0 | 1 | 0 | 0 | 0 | 2 | 1 | 1 | 3 | ||
8 | A | 2 | 2 | 2 | 1 | 1 | 2 | 0 | 0 | 0 | 1 | 0 | 1 | 2 | 2 | 0 | 1 | 0 | 0 | 2 | |||
04 - 05 SCORES |
This is where the formulas are, all are fine if the data range contains data in every cell. However, when i clear the contents to input new data my formula for counting draws, cell AM5, is counting blanks. Not what i want.
Hope i've made things clear, thanks in advance.
What happens when there is no data, Cell AM5 shows 19 draws. Not what i want.