Help: House Bill Computation (Divider)

[Donskie]

So, i'm planning to make an excel sheet to divide a House Electricity Bill among the users.

Here's the Situation:
- This is for the Electric Bill distribution among 15 people who live in the same house.
- The bill has to be divided among all and also on how many days they have stayed and used the service.

Please see the attached sheet to have more idea on what i'm trying to achieve.

Help.

[alvin-chung]

Hi, try copy this formula across AG4:AG18

=AG$2*COUNTIF(B4:AF4,"y")/COUNTIF(B$4:AF$18,"y")

_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

[Donskie]

Brilliant. Thanks! how can I mark this solved?

[alvin-chung]

You're welcome, thank you for the feedback
ps: I noticed that this thread had been marked as SOLVED, here's the link in case you would like to know more http://www.excelforum.com/faq.php


_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

[alvin-chung]

You're welcome, thank you for the feedback
ps: I noticed that this thread had been marked as SOLVED, here's the link in case you would like to know more http://www.excelforum.com/faq.php


_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin