| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF clause for a range of cells
Try
=SUM(G8:AJ8)+(COUNTIF(G8:AJ8,"")*4) -- Jacob "Al" wrote: The following formula works well for me but is there a way to make it shorter by defining a range of cells, rather than individual cells, in the IF part? =SUM(G8:AJ8)+IF(G8="",4)+IF(H8="",4)+IF(I8="",4)+I F(J8="",4)+IF(K8="",4)+IF(L8="",4)+IF(M8="",4)+IF( N8="",4)+IF(O8="",4)+IF(P8="",4)+IF(Q8="",4)+IF(R8 ="",4)+IF(S8="",4)+IF(T8="",4)+IF(U8="",4)+IF(V8=" ",4)+IF(W8="",4)+IF(X8="",4)+IF(Y8="",4)+IF(Z8="", 4)+IF(AA8="",4)+IF(AB8="",4)+IF(AC8="",4)+IF(AD8=" ",4)+IF(AE8="",4)+IF(AF8="",4)+IF(AG8="",4)+IF(AH8 ="",4)+IF(AI8="",4)+IF(AJ8="",4) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PERCENTILE with an IF Clause | Excel Worksheet Functions | |||
| Multiple values for LOOKUP? Maybe add IF clause? | Excel Worksheet Functions | |||
| $ sign in SQL clause in MS Query | Excel Discussion (Misc queries) | |||
| IF Clause | Excel Worksheet Functions | |||
| "Between" in an IF clause | Excel Discussion (Misc queries) | |||
Threaded Mode
