A and B column query to provide Sum of column C
Solved/Closed
Rian Crabtree
-
Updated by Rian Crabtree on 29/11/16 at 04:38 PM
yg_be Posts 22793 Registration date Sunday June 8, 2008 Status Contributor Last seen May 18, 2024 - Nov 29, 2016 at 05:21 PM
yg_be Posts 22793 Registration date Sunday June 8, 2008 Status Contributor Last seen May 18, 2024 - Nov 29, 2016 at 05:21 PM
Related:
- A and B column query to provide Sum of column C
- Excel copy column from one sheet to another automatically - Guide
- Sum column if another column equals ✓ - Excel Forum
- Sum if greater than and less than cell value ✓ - Excel Forum
- Excel count how many times a value appears in a column ✓ - Office Software Forum
- Pldt can't provide internet ✓ - WiFi Forum
1 response
yg_be
Posts
22793
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
May 18, 2024
5
Nov 29, 2016 at 05:21 PM
Nov 29, 2016 at 05:21 PM
Try this :
=SUMIFS(C1:C8;A1:A8;"abc";B1:B8;"y")
=SUMIFS(C1:C8;A1:A8;"abc";B1:B8;"y")