Double quotes is used to refer anything which is not a cell reference OR a
numeric value..

For Text strings, ,=< etc; you need to enclose within quotes.

So "=70" is same as "=" & 70 (since 70 is numeric)

'&' combines the text string within quotes with the numeric value..

If this post helps click Yes
---------------
Jacob Skaria


"Cazzy123" wrote:


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