Related:

- How to calculate filtered value
- How to calculate 90 days from date in excel - Guide
- How to calculate vat in excel - Guide
- How to calculate percentage to paisa - Office Software Forum
- Calculate mtu - Guide
- How to calculate aggregate - Excel Forum

## 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