need help with a function

K

Kerry Bennett

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Formula Help 5
Complicated IF statement - desperately need some help 4
i need help with a formula 7
Count...Sum...Faster...improvemens...; Have a good end of YEAR 2
Print Subtotals of variable entries 2
need help with a function 0
Need help ( Hope i made it clear this time) 1
SumIf and vlookup formula help 2

Top