| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
percentage
Hi, I trying to write a formula that will look in column b for 'building A'
and calculate the number of times the cost is <500, as a percentage. 2 entries but only 1 is <500. Should return 50% a2:b100 cost location 500 building a 100 building b 250 building c 100 building a |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percentage of | Excel Worksheet Functions | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| percentage | Charts and Charting in Excel | |||
| percentage | Excel Discussion (Misc queries) | |||
| Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel | |||
Threaded Mode
