View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cazzy123 Cazzy123 is offline
external usenet poster
 
Posts: 14
Default Using " " in If functions


Hi I have 2 If functions:

=SUMIF(C3:C7;TRUE;B3:B7) and =COUNTIF(B2:I2;"=70")

Although I understand the equation behind it I always get confused as to
when I should use the " " . As from my examples one of they are required
only in one of these functions.

Could someone please make it easier for me to remember when any why they
should be used.

Thanks