hi
I have attached a sample workbook of a desired outcome. The data in the Register Sheet needs to be counted and tallied into the individual sheets as per the workbook wither through a formula or vba.
w want to sum how many times each sub category in the Register sheet appears for a specific district and then copied to the relevant sheet.
your assistance is appreciated.
sum based on conditions
-
roninn75
- 3StarLounger
- Posts: 236
- Joined: 15 Feb 2013, 08:25
sum based on conditions
You do not have the required permissions to view the files attached to this post.
-
Rudi
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: sum based on conditions
Hi Ronin,
The attached workbook show how you can set up a SUMIFS() function to calculate the values you need. Please verify if the results are accurate and what you expect.
Also note that I formatted the first block on each sheet to use this custom number format: 0;-0;;@
This will hide zeros since it would complicate the formula much more to do it in the calc. Cell formatting is quicker.
The attached workbook show how you can set up a SUMIFS() function to calculate the values you need. Please verify if the results are accurate and what you expect.
Also note that I formatted the first block on each sheet to use this custom number format: 0;-0;;@
This will hide zeros since it would complicate the formula much more to do it in the calc. Cell formatting is quicker.
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.