Thread: is there any way to have multiple TEXT criteria in a 'sumif' funct
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
  
Posts: 1,688
Default is there any way to have multiple TEXT criteria in a 'sumif' funct
Hi!

Try this:

=SUM(SUMIF(A1:A10,{"word_1","word_2"},D1:D10))

Biff

"datasorter" wrote in message
...
I'm trying to run a sumif function from two different words in the same
row
and then sum the range three cells to the right.

Any ideas?


Reply With QuoteReply With Quote