Yes, I think you are correct. I ws thinking about it last night and decided
to try something in the sum column.

B C (D E F) G

ENG4C1 ENG3U1 ENG3U1 0 0 0 = 1.33

Here is the formula that I was using to add the 6 columns.
=ROUND((COUNTIF(B8,"<")+COUNTIF(C8,"<")+COUNTIF( G8,"<")+MIN(COUNTIF(D8:F8,"<"),1))/3,2.
So I need to adjust this column to get the result I would like.

thanks

"Gord Dibben" wrote:

A cell with a formula can never return "nothing".

You can make it look blank by trapping

=IF(A1="","",A1)

Where have you arbitrarily set a cell to return .33 when not completely
blank?

I think that is where you should be doing the correction.


Gord Dibben MS Excel MVP


On Fri, 16 Oct 2009 12:33:01 -0700, Newfie809 wrote:

Hi Adam,

What I am looking for is the cell returns nothing. When something is in the
cell it will count as a .33 I have 4 columns and in each cell of the 4
columns there is a formula that will return a .33 and that will add up to 133
and I only want it to add up to 100 therefore the cell should return with
nothing because even with the zerro the cell thinks there is something there
and it will return a .33. I don't know if I amy explaining it correctly do
you understand what I am trying to do. I could delete the zerro but then I
am deleting the formula also and I need the formula there, just in case on
the other spread sheet the information changes in each column.


Thank you for your response.

.