View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Jim is offline
external usenet poster
 
Posts: 615
Default COUNTIFS Formula Problem

Has anyone experienced any substantial errors from the Countifs Formula?

A B C
1 15 51 30

3 20 30 18
4 20 15 18
5 15 51 30


COUNTIFS(A3:C3,A1,A4:C4, B1,A5:C5, C1) = 0 when it should equal 1

Is my syntax wrong? This what the formula produces?

Any ideas?