A and B column query to provide Sum of column C
Solved/Closed
Rian Crabtree
-
29 Nov 2016 à 16:36
yg_be Posts 23437 Registration date Sunday 8 June 2008 Status Contributor Last seen 6 June 2025 - 29 Nov 2016 à 17:21
yg_be Posts 23437 Registration date Sunday 8 June 2008 Status Contributor Last seen 6 June 2025 - 29 Nov 2016 à 17:21
Related:
- A and B column query to provide Sum of column C
- Excel column number - Guide
- How to delete a column in word - Guide
- Tweetdeck expand column - Guide
- Excel count number of occurrences in a column - Guide
- How do trains provide wi-fi - Guide
1 response
yg_be
Posts
23437
Registration date
Sunday 8 June 2008
Status
Contributor
Last seen
6 June 2025
5
29 Nov 2016 à 17:21
29 Nov 2016 à 17:21
Try this :
=SUMIFS(C1:C8;A1:A8;"abc";B1:B8;"y")
=SUMIFS(C1:C8;A1:A8;"abc";B1:B8;"y")