Execl - Copy forumlas to multiple worksheets

Closed
MEB - Aug 14, 2009 at 03:49 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 14, 2009 at 08:35 PM
Hello,

I am having trouble copying formulas to multiple worksheets.

On the sheet name tab, I click "select all sheets" then I type in my formula

=SUMPRODUCT(($M$8:$M$20)*($K$8:$K$20="Discretionary Fund")*($J$8:$J$20=DATE(2009,7,5)))

The formula copies into all the other worksheets just fine, and works great in the first worksheet, but on all the subsequent worksheets I get #VALUE.

Help!

Thanks!
MEB

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Aug 14, 2009 at 08:35 PM
in other sheets check whether in the data range referred to in the formula do have some error entries like #N/A.
0