Thread: Criteria Syntax in SUMIF formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RollieG RollieG is offline
external usenet poster
  
Posts: 11
Default Criteria Syntax in SUMIF formula
How do you use SUMIF, when your criteria is one of two(or multiple) values?

For Example, I want to use:

=SUMIF(A2:A10, ($C$1 or $D$1), B2:B10), but I know ($C$1 or $D$1) is not the
correct syntax.


Reply With QuoteReply With Quote