| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statement on a range of cells in Excel 2007
Hi,
I'm trying to put up this formula: =SUM(IF((G17:G31="Y"),($C17:$C31*80),0)) so that it multiplies with 80 and then sums all those values C17 through C31 for which values of G17 through G31 are Y. But this gives me a value error in excel. When I remove the range and enter a single cell, it works fine. I'm not sure what I'm doing wrong here. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Statement for Cells in a Range | Excel Discussion (Misc queries) | |||
| Excel 2007 crashes on entering data in a specific range of cells | Excel Discussion (Misc queries) | |||
| Excel 2007 Filtering range | Excel Discussion (Misc queries) | |||
| Excel 2007 Range Selection | Excel Discussion (Misc queries) | |||
| Using variables as first and last cells in range statement | Excel Worksheet Functions | |||
Threaded Mode
