Thread: Function to Use when compare sums another column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Heather Heather is offline
external usenet poster
  
Posts: 148
Default Function to Use when compare sums another column
I have and age Field and a Column that contain counts.
If the aging Column contains a number between =0 and <=30 I want it to sum
up the counts that correspond in field B2.

I tried the following and keep getting invalid returns.

=SUM(IF(MATCH("<=30",Sheet2!F:F,0),INDEX(Sheet2!B: B,MATCH("<=30",Sheet2!F:F)),0))
Reply With QuoteReply With Quote