for calculating p/e 's for 2005 and 2006, earnings for 2005 and 2006 are
u.r. so to calculate the overall p/e s i have to remove the price for
the companies whose earnings is u.r. you can see in the datesheet.xls

how can you write a formula (more than one criteria maybe)
when a cell is not a number
so that i can find true total aggregate numbers

i have tried to form a criteria and sumproduct formula
but more than one earnings or criterias it is not useful

and could not go any further

are the any masters over there to write a formula to find the correct
result
P/e for 2005E : 44.4 and 2006E 28.6

thanks in advance


+-------------------------------------------------------------------+
|Filename: datasheet.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4083 |
+-------------------------------------------------------------------+

--
barkiny
------------------------------------------------------------------------
barkiny's Profile: http://www.excelforum.com/member.php...o&userid=20397
View this thread: http://www.excelforum.com/showthread...hreadid=489448