LinkBack URL
About LinkBacks
Hi,
Can someone pls explain to me meaning of below formula:
=CONCATENATE("Overall Score = ",ROUND((SUMIF($E$4:$E$336,">=0"))/(COUNTIF($E$4:$E$336,">=0")*0.02),2),"%")
Thx,
Arke
Hi,
Can someone pls explain to me meaning of below formula:
=CONCATENATE("Overall Score = ",ROUND((SUMIF($E$4:$E$336,">=0"))/(COUNTIF($E$4:$E$336,">=0")*0.02),2),"%")
Thx,
Arke
The formula will give you the 2% of the average of range E4:E336 for all values that are greater than zero. this will be rounded off to two decimals and the display text will be something like this
Overall Score = x.xx%
Life's a spreadsheet, Excel!
Say thanks, Click *
Hi,
Ace_XL is absolutely right.
If you are using excel 2007 and above, I think below will be the shorter version of your formula.
="Overall Score = "&ROUND(AVERAGEIF($E$4:$E$336,">=0",$E$4:$E$336)*0.02,2)&"%"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks