| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to edit formula without changing formula of each cell
Hello,
My problem is: I use a very large formula:=SUMPRODUCT(--(TEXT(F13:F59,"yyyymmm")="2007Jan"),J13:J59). and the formula is used in more than 1000 cells. but the month name and range changes according to row and column of every cell. How can I change the formula of every cell without selecting each cell and editing manually? I would be very much thankful if anyone can help me with this problem. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to edit formula without changing formula of each cell
If you want to replace only "2007Jan", select only the cells you want and
Find/Replace -- Rodrigo Ferreira "sadat" escreveu na mensagem ... Hello, My problem is: I use a very large formula:=SUMPRODUCT(--(TEXT(F13:F59,"yyyymmm")="2007Jan"),J13:J59). and the formula is used in more than 1000 cells. but the month name and range changes according to row and column of every cell. How can I change the formula of every cell without selecting each cell and editing manually? I would be very much thankful if anyone can help me with this problem. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to edit formula without changing formula of each cell
change your formula to
=SUMPRODUCT(--(month(F13:F59)=month#)--(year(F13:F59)=year#),J13:J59) You can put the month# and year# values in cells and change the formula above to reference the cells, not specifice vlues. "sadat" wrote: Hello, My problem is: I use a very large formula:=SUMPRODUCT(--(TEXT(F13:F59,"yyyymmm")="2007Jan"),J13:J59). and the formula is used in more than 1000 cells. but the month name and range changes according to row and column of every cell. How can I change the formula of every cell without selecting each cell and editing manually? I would be very much thankful if anyone can help me with this problem. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro help for changing data (cell location) in edit find box | Excel Discussion (Misc queries) | |||
| can't edit a cell with a formula | Excel Worksheet Functions | |||
| i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
| How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
| edit number in cell without it changing to text | Excel Discussion (Misc queries) | |||
Hybrid Mode
