Excel

1. Countifs with multiple criteria in single criteria range

=SUM(COUNTIF(M1:M12,{“A”,”B”,”C”}))
=SUM(COUNTIFS(M1:M12,{“A”,”B”,”C”},B1:B12,{“D”,”E”,”F”))

2. SUMIF with multiple criteria

=SUMPRODUCT((A1:A10>100)*(B1:B10)*(C1:C10<J10))

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