Thread
:
Excel formula, 2 colons query to sum values in colon 3
View Single Post
#
1
Posted to microsoft.public.excel.programming
Dirk
external usenet poster
Posts: 5
Excel formula, 2 colons query to sum values in colon 3
I need a formula like SUMIF but the query should be in TWO colons.
A B C
1 a x 2
2 a x 1
3 b x 1
4 b y 3
if A1:A4="a" AND B1:B4=x then SUM C1:C4
Reply With Quote
Dirk
View Public Profile
Find all posts by Dirk
Excel formula, 2 colons query to sum values in colon 3