Try this:

=SUM(IF(E2:E547={391,58},H2:H547))
this is an array formula so enter it using CTRL+SHIFT+ENTER

HTH
JG

"shalombi" wrote:


how can i add multiple possibilities ?
i tried separating by commas, or, || and all i knew from programing and
it didnt work.
=SUMIF(E2:E547,"=391",H2:H547)
if i want to have also lets say 58 in their

=SUMIF(E2:E547,"=391,58",H2:H547)
i tried many different things and none worked

Max


--
shalombi
------------------------------------------------------------------------
shalombi's Profile: http://www.hightechtalks.com/m899
View this thread: http://www.hightechtalks.com/t2352985