Excel return sum of variable date in row where criteria is met

Question

I need to find a date in a row 3:3, and then add all the amounts in that column where in a different column A:A the text is = to a specific criteria

Criteria	1/1	1/2	1/3
Bob	1	4	2
Sue	3	1	3
Jill	1	1	1
Bob	2	1	1
Sue	2	3	0

I tried sumifs but I get a #value error because the criterias aren't the same size.

What I want: To know the sum for Bob on some variable date. For example if I put in 1/2, the answer should come out to 5. But if I change the date option to 1/1 the sum for Bob should be 3.

rotabor · Accepted Answer · 2024-11-15 00:05:34Z

3

It can be the simple solution:

[F6]=SUM(B2:D6*(A2:A6=F2)*(B1:D1=F4))

answered Nov 15, 2024 at 0:05

rotabor

5,6112 gold badges5 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Meagan Hartsock Over a year ago

This is perfect and glaringly obvious now, sometimes the simple solution is the hardest to get to, thank you.

Collectives™ on Stack Overflow

Excel return sum of variable date in row where criteria is met

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related