Multiple criteria sums
Solved/Closed
Related:
- Multiple criteria sums
- Mpc hc multiple instances - Guide
- Split excel sheet into multiple files - Guide
- How to delete multiple files on mac - Guide
- Excel multiple lines in one cell - Guide
- Multiple if statements in excel with text ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 22, 2010 at 05:35 PM
Jul 22, 2010 at 05:35 PM
Try this
=SUMPRODUCT( (LEFT(A$1:A$5,3)="INC") *( YEAR(B$1:B$5)= 2009)*(C$1:C$5))
You can also use
=SUMPRODUCT( (ISNUMBER(SEARCH("*INC*",A$1:A$20))) *( YEAR(B$1:B$20)= 2009)*(C$1:C$20))
=SUMPRODUCT( (LEFT(A$1:A$5,3)="INC") *( YEAR(B$1:B$5)= 2009)*(C$1:C$5))
You can also use
=SUMPRODUCT( (ISNUMBER(SEARCH("*INC*",A$1:A$20))) *( YEAR(B$1:B$20)= 2009)*(C$1:C$20))
Jul 23, 2010 at 07:16 AM