Execl - Copy forumlas to multiple worksheets [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
in other sheets check whether in the data range referred to in the formula do have some error entries like #N/A.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!