New Project

[maitai11]

Hi Everyone!

Been a few years since I came here; I have a new project to tackle! Here's the help I'm seeking:

(A) DATE (B)Value varies (C)6.00 (D)75.00 (E)150.00 (F)Subtotal Row

(B) 145.90
(B) 160.75

(C) 6.00

(E) 150.00

(B,C,D,E,) Subtotal Ea Column

(F)Sum Total All


1. Column B value varies.
2. Column C, D, E values are fixed
3. I would like subtotal of each column
4. I would like subtotal of each row in "F"
5. I would like total of ALL "row" subtotals at the bottom of "F"

THANKS IN ADVANCE FOR ALL THE HELP!!!

Maitai

 

[anandvarma]

Try pivot table, you will get all types of totals
you are presently looking