sSorry, I missed/forgot the most important part. The TAX LIABILITY value in
W5 get devided into either ALL the cells in H6:S6 or only part/half the year
as in M6:S6, if only employed half a year.

Thanks once more...



"Jay" wrote:

Okay,..Fred, simple request, here goes...

At times row/cells H5:S5 may contain a value like 1380.00 in everyone of the
cells depending on if the employee became employeed the full year. However,
if he/she started half way into the year, say cell M5:S5, then, only about
half of those cells would have a value of 1380.00. The =Sum() function
generates a Tax value (in cell W5) based on the total! However, that total
number of cells containing a value drops off by half for HALF a year. So I
need to devide the total tax value by whatever number of cells have values,
either ALL of the cells from S6:H6 going backwards/right to left (or half
that number), instead of left to right in row/cells H5:S5!
================
Income Example #1
H5 I5 J5 K5 L5 M5 N5 O5 P5
Q5 R5 S5
1380 1380 1380 1380 1380 1380 1380 1380 1380 1380
1380 1380
Tax Liability
H6 I6 J6 K6 L6 M6 N6 O6 P6
Q6 R6 S6
25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00
25.00 25.00
================
Half Year Income Example #2
H5 I5 J5 K5 L5 M5 N5 O5 P5
Q5 R5 S5
1380 1380 1380
1380 1380 1380 1380
Half Year Tax Liability
H6 I6 J6 K6 L6 M6 N6 O6 P6
Q6 R6 S6
25.00 25.00 25.00
25.00 25.00 25.00 25.00
================

I hope this example explains what I'm trying to accomplish!!!

I need to show an Income tax value in the row/cells below in H6:S6, which
would be tied to the income values in the cells H5:S5 or only half.

Than, again Fred....



"Fred Smith" wrote:

It's the other way around, Jay. You give us the example, and we'll show you how
to do it. I can't tell from your question what you are looking for. Tell us
what's in H5, and what you want to see in H6. It could be as simple as
=if(h5="","",yourformulahere), but I can't tell until I know what results you
want.

--
Regards,
Fred


"Jay" wrote in message
...
Thanks Fred:

Now, as I attempt to populate the cells below which is row H6:S6, how would
I get that to fill in only a value in row H6:S6 or whatever based on the
populated cells above in H5:S5? This is where I get totally lost! Can you
help explain more clearly by example?

Thanks,...



"Fred Smith" wrote:

Rather than dividing by 12, just divide by COUNT(H5:S5). Count ignores blank
cells, so you'll get the total number of cells that have data.

--
Regards,
Fred


"Jay" wrote in message
...
Guru's

I have a question which may be a brain buster! "Can I have Excel devide a
resulting value by only the number of cells containing data? Examle, I have
row/cells "H5" - "S5" values being calculted in a =Sum() function in cell
"U5", however, the total value is now looked at using a "VLookUp" function
on
another sheet to see what the Tax liability is and places that value in
cell
"V5" (Single) and "W5" jointly filing.

If ALL the cells from "H5" - "S5" contain income values, then, that is
great, all I need to is devide the total Tax liability by those 12 months
to
get my monthly Tax liability value in cell "H6" - "S6"! But, what if the
values run from say; "M5" - "S5", can I have the Tax liability the devided
(calculated) by only those cells in "M6" - "S6"? I need the formula to look
at the cells in reverse from "S5" back to "H5", see if any are blank or
empty
cells, trip those off and devide the total value in "V5" or "W5" by only
those cells placing the results in whatever cells need to show a value from
"S6" back to "H6"?

Is this possible, I know, it sounds crazy, doesn't it? But, really,...is it
possible?

Thanks, looking forward to hearing back from you guys....