Execl - Copy forumlas to multiple worksheets

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
in other sheets check whether in the data range referred to in the formula do have some error entries like #N/A.