Related:

- How to calculate filtered value
- How to calculate 90 days from date in excel - Guide
- How to calculate vat - Guide
- How to calculate aggregate percentage - Excel Forum
- How to add snapchat filter to existing video - Guide
- How to calculate in spreadsheet - Guide

## 1 response

If I understand you correctly your sheet looks a bit like this:

Price Group Month 12 A Jan 35 A Feb 46 B Ok 86 B Jan 75 C Feb 96 A Feb 43 B Jul 38 A Jan 75 A Feb 65 A Okt 14 A Nov 58 C Dec 86 C Jan

Now, as an example, you would like to know the total price for group A of the month Feb.

In this case the conditions is met in line 3, 7 and 10 coming to a total of 206 (35+96+75).

Use the following array formula in any cell desired outside of the array(A1:C101):

=SUM((C2:C101="Feb")*(B2:B101="A")*(A2:A101))

Confirm this formula by hitting Ctrl+Shift+Enter.

As you can see I used a larger range in the formula then actual data, so you can add more data without having to constantly change the formula. You can make the range a big as you like.

Best regards,

Trowa