Related:
- How to calculate filtered value
- How to calculate 90 days from date in excel - Guide
- How to calculate in spreadsheet - Guide
- How to calculate vat in excel - Guide
- How to calculate bece grades - Excel Forum
- How to calculate number of words in ms word - Guide
1 response
Hi Bebekku,
If I understand you correctly your sheet looks a bit like this:
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
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
