Thread: Creating a formula that will SUM with 2 Variables
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
B Akers
 
Posts: n/a
Default Creating a formula that will SUM with 2 Variables
I have been trying to figure out how to create a formula in Excel 2003 that
will sum only if 2 variables are met. An example would be if you had 5000
rows of data. Columns are NAME, AGE, CITY. Let's say I wanted to sum how
many people are in Seattle and are 25 can Excel do this?
Reply With QuoteReply With Quote