I have some data in excel as below.

Date Head Amount

1.04.11 A1 200

1.04.11 A2 140

1.04.11 A1 20

2.04.11 A1 300

3.04.11 A1 120Now, I want to sum all the values in amount, where Date=1.04.11 and Head=A1. Please help me with appropriate function. i am a novice in excel.

I'm using excel 2007 but i wanted to use the formula in Google Docs also. Thanks in advance.

Finally, I got an answer from Net. It is as follows. =SUM(IF((A2:A6="1.04.11")*(B2:B6="A1"),C2:C6)).

Thanks!

Ask Your Question

Weekly Poll