T
Tat
I created an array formula to do the following. If pay
type = the criteria I specify and the month equals the
month I specify then add all the amounts in another array
column that meets the criteria. This formula was adjusted
to reflect a calculation for every month for every pay
type.
Formula is:
=SUMPRODUCT(($A$7:$A$500=$P$6)*($H$7:$H$500=$L7)*
($K$7:$K$500))
This formula was copied for 5 pay types (Ie MC,VISA,DEBIT,
etc) and 12 months (Jan to Dec) for each pay type.
First, I created this formula in a spreadsheet that I
would normally use it in. Then I copied the formula in a
blank spread sheet so that I could use it in a macro to
copy and paste when I needed it on subsequent spreadsheets.
When I call the macro the above grid with the formulas are
copied. However, the formulas do not work. When double
click the box with a formula, the correct formula shows
and it even points to the correct arrays (criteria,etc.)
This worked yesterday on several spreadsheets. But it does
not work today. Any suggestions?
type = the criteria I specify and the month equals the
month I specify then add all the amounts in another array
column that meets the criteria. This formula was adjusted
to reflect a calculation for every month for every pay
type.
Formula is:
=SUMPRODUCT(($A$7:$A$500=$P$6)*($H$7:$H$500=$L7)*
($K$7:$K$500))
This formula was copied for 5 pay types (Ie MC,VISA,DEBIT,
etc) and 12 months (Jan to Dec) for each pay type.
First, I created this formula in a spreadsheet that I
would normally use it in. Then I copied the formula in a
blank spread sheet so that I could use it in a macro to
copy and paste when I needed it on subsequent spreadsheets.
When I call the macro the above grid with the formulas are
copied. However, the formulas do not work. When double
click the box with a formula, the correct formula shows
and it even points to the correct arrays (criteria,etc.)
This worked yesterday on several spreadsheets. But it does
not work today. Any suggestions?