Condition in Subtotal?

Hi
I have the following matrix
CA AZ

No surplus 11 5

---

Surplus 12 10

---

Zotal 100 50

---

Totlal 123 65

---

I want that only (No surplus and Surplus) sum include in total Can I apply This condition on Subtotal.

thanks in advance

Hi Yaseen,

Take a look to this post. This will help you out.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1315844&SiteID=1

Bernard Ong