filter function,sum 1 range ,multiple criteria

Question

filter function,sum 1 range ,multiple criteria

Anonymous

My array is A:F, sumrange=D1:D6, criteria range=F1:F6,creiteria 1=X, Criteria 2= Y. How to sum values OF Criteria 1 and 2 , 1 or 2, 2 or 1, dates March,2023

A	D	F
all March dates full column	2	X	A :A range	Dates
	1	Y	Sum X and Y	8
	4	L	Sum X	2
	3	Z	Sum Y	6
	5	K	if X or Y not exists	0
	5	Y

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

0 additional answers

Answer 1

You may try:

X and Y

=SUM(FILTER(D2:D7,(F2:F7="X")+(F2:F7="Y")))

X

=SUM(FILTER(D2:D7,(F2:F7="X")))

Y

=SUM(FILTER(D2:D7,(F2:F7="Y")))

What do you mean X or Y not exists? Not X and not Y?

=SUM(FILTER(D2:D7,(F2:F7<>"X")*(F2:F7<>"Y")))

If you filter on date in H2. mutiple "(TEXT(A2:A7,"MMYYYY")=TEXT(H2,"MMYYYY"))" in each criteria.

=SUM(FILTER(D2:D7,((F2:F7="X")+(F2:F7="Y"))*(TEXT(A2:A7,"MMYYYY")=TEXT(H2,"MMYYYY"))))

Share via

filter function,sum 1 range ,multiple criteria

0 additional answers