| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need help with a function
=SUMIF(B5:B7,"yes",C5:C7)/SUM(C5:C7)
JOB NAME LOCAL JOB BAG COUNT pool yes 100 gym no 300 school yes 500 TOTAL 67% 900 regards, Kerry Bennett www.excelaid.com -----Original Message----- i need to make a function that will allow me to add bag counts only for the ones with "yes" and divide that by the total bag count and get a percentage for an answer at the bottom of the LOCAL JOB column. based on my example below: JOB NAME LOCAL JOB BAG COUNT pool yes 100 gym no 300 school yes 500 TOTAL ??% 900 Thanks in advance to anyone who can help. Kim . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Threaded Mode
