Execl - Copy forumlas to multiple worksheets [Closed]

Question

Execl - Copy forumlas to multiple worksheets [Closed]

Report

MEB - Aug 14, 2009 at 03:49 PM
venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

- 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

Execl - Copy forumlas to multiple worksheets
Creating multiple worksheets from a template and a list of names ✓ - Forum - Excel
Create a reference to the same cell range on multiple worksheets - How-To - Excel
Copying formulas to multiple worksheets ✓ - Forum - Excel
Protecting your formulas in multiple worksheets ✓ - Forum - Excel
Duplicate rows from multiple worksheets ✓ - Forum - Excel

1 reply

Ask a question

venkat1926 · Answer 1 · 2009-08-14T20:35:51-0400

Answer 1 / 1

venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

796
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.

Execl - Copy forumlas to multiple worksheets [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!