LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jay Jay is offline
external usenet poster
 
Posts: 671
Default Calculating only non-empty cells...

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....


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying values but skipping empty cells Handyy Excel Worksheet Functions 1 February 9th 06 01:41 AM
DATEVALUE & Empty cells mla75 Excel Worksheet Functions 2 January 5th 06 04:20 PM
how insert same text in empty cells in column (10000 rows) bromptongadgets Excel Worksheet Functions 1 December 11th 05 03:13 PM
Matrix multiplication with empty cells Ingrid Voigt Excel Worksheet Functions 2 March 8th 05 03:47 AM
Getting rid of empty cells Jambruins Excel Discussion (Misc queries) 2 February 22nd 05 04:38 PM


All times are GMT +1. The time now is 10:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"