TMS,
So this formula:
=SUMPRODUCT((('ENE 2012'!$B$5:$B$10=$B5)*('ENE 2012'!$C$5:$C$10=$C5)*('ENE 2012'!$D$5:$D$10)))
will only add the items on the 'Ene 2012' tab, do I have any options for adding across all the tabs?
Thanks,
John
TMS,
So this formula:
=SUMPRODUCT((('ENE 2012'!$B$5:$B$10=$B5)*('ENE 2012'!$C$5:$C$10=$C5)*('ENE 2012'!$D$5:$D$10)))
will only add the items on the 'Ene 2012' tab, do I have any options for adding across all the tabs?
Thanks,
John
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks