View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Todd
 
Posts: n/a
Default How do I count letters and numbers in a formula?

D I J M O <--column
How Type SP Bid Status <--Label
PM 21 AF 100 P
SC 41 AF 1000 L
CQ 11 DP 750 S

How do I get the sales totals for this? Count column D if it equals PM,
column I equals 21, and column O equals S, = sum column M. Please help.