SUMIFS with filtes

[smiles76]

This is an excert of my sheet. in reality there are 2000 sales per month but I have just put 8 down to give you an idea of what I need to do.

cell :-
A1= date
B1= staff name
C1= cust (customer) name
D1= receipt no.
E1= Colour
F1= Payment
G1= Amount

A B C D E F G
1 Date Staff Cust receipt no. Colour Payment Amount
Name Name

2 01/01/11 Colin X 255 Red card 11.99
3 01/01/11 Dave X 256 Blue cash 9.99
4 03/01/11 Sara X 257 Red cheque 8.99
5 03/01/11 Lisa X 258 Red card 9.99
6 03/01/11 Mary X 259 Pink cash 12.99
7 04/01/11 Colin X 260 Blue cheque 9.99
8 04/01/11 Lisa X 261 Pink card 8.99
9 04/01/11 Mary X 262 Blue cash 9.99
10
11 cash
12 red
13 blue
14 pink

the word :-
cash is in cell E11
red is in cell D12
blue is in cell D13
pink is in cell D14

so the answe to E12 needs to say add amounts in colum G if E= red & F=cash.

I can enter the following formula which works:-
=SUMIFS(G2:G10,F2:F10,E11,E2:E10,D12)

but I need to make a seperate tab for each day of the month and filter each tab to a different date.

When filtered the formula still added the values that are hidden but I only want the total of the amounts that show.

Please advise.