In need of Help

[sjackson]

Hi all, I was wondering if someone could help me out with a problem. I
am attempting to add up the efficiency for a full year. I think I am
on the right track with the formula that I have so far but it is taking
everything for that day. The problem is that I do not want it to count
the zeros. I need a formula that will add everything for a given day
but the zeros. Here is the formula that I have so far.

=SUMIF($B$150:$IV$150, "Monday",$B152:$IV152) /
COUNTIF($GF$150:$GP$150, "Monday")*100

Any help would be appericated.

 

[Bob Phillips]

Can you explain a bit further, which zeroes are you referring to? I am also
unsure as to what the SUMIF refers to a range of 255 cells, but the COUNTIF
refers to just 11 cells, and not related to the SUMIF ranges.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[sjackson]

Sure, the best way to describe what I am after is that I wish to have
running efficiency number for each line for an entire year, any da
with a zero cannot be counted. Within the company I work for, ther
are a few lines that do not run every day, so within the range of cell
there will be days where a where the efficiency will be 0. My proble
is that the zeros that are there now and will always be there, ar
skewing number for that lin, I cannot have that. There will be zero
put into the raw data but I do not want to have those days counted.
wish to sum up the row 152 as long as row 150 equals Monday. I wa
planning on using the sumif part of the formula and just change the da
because that side of the formula seems to be working. This will b
looked at that the senior people in the company and I wish to give the
the most accurate number I can. I hope this clarifies my problem. An
help will be appericated.

S

 

[Bob Phillips]

--

HTH

RP
(remove nothere from the email address if mailing direct)