View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ann ann is offline
external usenet poster
 
Posts: 210
Default multi-if then formula i think

i have 3 columns of data. basically i want to query column A and B, for a
particular range, and if it meets that range/criteria, sum the totals in
column C.
for example, if A=HW and B=ST, then sum every $ in column C with that
criteria.
for column A, there are 4 different choices (hw, ss, ms, sa) and for column
B, there are 7 choices...so basically i want each unique choice to sum the
results.
tia