Hello. I have this formula in about 1200 cells.
=IF(B9<>"",SUMIF(GL!$A$1:$A$217000,$B9&"-"&C$4,GL!$D$1:$D$217000)-SUMIF(GL!$A$1:$A$217000,$B9&"-"&C$4,GL!$C:$C),"")
I would like to change this formula into this formula (format) below for all of the cells? How can I do that?
=SUMPRODUCT(--(GL!$A$2:$A$217000=B9&"-"&$C$4),(B9<>"")*(GL!$D$2:$D$217000-GL!$C$2:$C$217000))
Hi there,
couldn't you provide this issue in the context of an example, illustrated in a spreadsheet?
Kind regards from HAmburg
Henning
If the formulae are all in one column and there is nothing between the formulae (like other formulae or text etc) enter the formula in the top cell of the column where the formulae start and then grab the fill handle (lower right corner of the cell) and drag down or simply double click the fill handle. Double clicking will fill the formula down until it comes across a blank cell so this might not work for you.
Another method to fill down (I will assume column M for the example).
Enter the formula in M5 (if that is where the formulae start) then, in the name box (left of the column headings and above the row numbers) enter M5:M1200 and hit enter. This will select M5:M1200. Then immediately do Ctrl + D to fill down.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks