View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kahuna kahuna is offline
external usenet poster
 
Posts: 7
Default SUMIF WITH MULTIPLE CRITERIA?

Hi there, need to sum up totals in a column, with 2 or more criteria:

eg:
A B C
USD LONG 10
EUR SHORT 10
USD LONG 10
USD SHORT

need to SUMIF if Column A is USD AND Column B is LONG..in this case to
return 20
also maybe other columns with additional criteria...can it be extended?

thanks!