SUMIF

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hi,

I need a similar function to sumif, but I need it to SUM
the values if they correspond to any number within an
array.

eg, answer would be 2 if


1 0.5
2 1.5
3 7
4 9


so I need it to sum from the array 1,2


Any ideas?
 
Thaks but that doesn't help sorry.

I need the function to recognise from an array and then
find the corresponding product. Someone help please
 
Thaks but that doesn't help sorry.

I need the function to recognise from an array and then
find the corresponding product. Someone help please
 
Hi not quite sure but my formula would return 2 for your example. What
do you mean with 'array'
 
=sumif(B1:B10,OR('1','48A','3/2'),C1:10)

Where the OR bit is an array of random values. But I don't
think you can put an array in the conditions for sumif.
 
See one solution in .misc. Please don't post the same question in
multiple newsgroups - it just fragments any answers you get, and wastes
the time of those answering questions that already have been answered
elsewhere.
 
Back
Top