mercredi 5 juillet 2017

Excel: SUMIF column A = x and (y or z)

Here is an example of the data I am using.

0 | A | B
1 | Information | Time
2 | --------- | ---------
3 | x y abc | 3
4 | x z abc | 4
5 | y z abc | 5

I would expect this to return the value 7.

I understand SUMIF(B:B,A:A,"x") and using SUMIF for multiple criteria but I am struggling to figure out how to integrate the ability for an and/or SUMIF.

Aucun commentaire:

Enregistrer un commentaire