| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing conditional sum format to "Sum If"
I am currently using
=SUM(IF(Data!$E$2:$E$1700=2467,Data!$Q$2:$Q$1700,0 )) But I would instead like to reference cell B2 of the current worksheet rather than typing 2467. The reason being, I'd like to be able to drag this calculation down, and have the formula in the cell just below reference cell B3 of the current worksheet, etc. Are there any sumproduct experts available who could steer me in the right direction? Gina |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop "global" hyperlinks changing to "local" links? | Excel Worksheet Functions | |||
| Excel: Changing "numeric $" to "text $" in a different cell. | Excel Worksheet Functions | |||
| " / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
| " / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
![Gina[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
