Sumproduct, OR in condition?

[larindom]

Hi,

I need a little help. I believe it should be possible with Sumproduct, but I am not entirely sure.

I have a dataset that looks like this:

Monday 1
Tuesday 2
Wednesday 3
Monday 1

I want the sumproduct to sum all instances that says Monday OR Tuesday, so the result is 4. How do I do that?

Brgds,
Lasse

 

[Scott T]

Assuming that the days are text not dates formatted to show the day then this should work. Where A1:A4 has the days and B1:B4 has the numbers

=SUMPRODUCT(--(A1:A4="Monday")*B1:B4+--(A1:A4="Tuesday")*B1:B4)

 

[Aladin Akyurek]

1. Better...

=SUM(SUMIFS(B:B,A:A,{"Monday","Tuesday"}))

2. Or if needed...

=SUMPRODUCT($B$2:$B$5,--ISNUMBER(MATCH($A$2:$A$5,{"Monday","Tuesday"},0)))

 

[pgc01]

Also:

=SUMPRODUCT(--(A1:A4={"Monday","Tuesday"}),B1:B4)

 

[larindom]

Hi pgc01 - your solution seems the simplest... but I cannot make it work?

I am on a European computer and have written this (adjusted for Danish and my dataset):
=SUMPRODUCT(--(D:D={"Fredag";"Tirsdag"});H:H)

I like your solution, as I have to include other criterias as well. Which means that my dataset might look more like:
Monday West 2
Tuesday East 4
Wednesday West 5
Friday East 1

 

[larindom]

Nevermind - I solved it with your help and a friend! Thx all!!