Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I nest COUNTIF functions(C5:C8,"apples") AND (D5:D8,"green") | Excel Worksheet Functions | |||
Functions for "current" & "previous" month to calculate data | Excel Worksheet Functions | |||
Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
can we convert "2 days 16 hrs" to " 64hrs" using excel functions | Excel Worksheet Functions |