Excel Functions

auto fill with column names 

=INDEX(Sheet1!$1:$1, ROW())

 

multiple condition lookup

=SUMIFS($I$46:$I$119,$G$46:$G$119,B1,$H$46:$H$119,B2)

 http://chandoo.org/wp/2010/11/02/multi-condition-lookup/

 

CountIf for AND criterias

=SUM((A2:A10=”Cars”)*(B2:B10=”Black”))

http://www.officearticles.com/excel/count_using_multiple_criteria_in_microsoft_excel.htm

Advertisements
Post a comment or leave a trackback: Trackback URL.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: