fn return range of cells that satisfy a condn

Microsoft Office excel 2007 - upgrade
April 3, 2011 at 23:45:04
Specs: Windows 7
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 120

Now, 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.


See More: fn return range of cells that satisfy a condn

Report •

#1
April 3, 2011 at 23:58:02
I'm using excel 2007 but i wanted to use the formula in Google Docs also. Thanks in advance.

Report •

#2
April 4, 2011 at 00:44:10
Finally, I got an answer from Net. It is as follows.

=SUM(IF((A2:A6="1.04.11")*(B2:B6="A1"),C2:C6)).

Thanks!


Report •
Related Solutions


Ask Question