hi guys i have a formula that works in one sheet ( monday stats h2 )
and even though ive carried it across and changed the reference on trowe stats it comes up with value error
if someone could help id be happy
please find attached
also in monday stats id like it to input in monday stats m4
the highest number represented in column a on monday sheet which should be 31
Try:
=SUMPRODUCT((TROWSE!$B$2:$B$2000='TROWSE STATS'!$D2)*(TROWSE!$D$2:$D$2000))
or better, define named ranges.
Although you specify whole columns in SUMPRODUCT in 2007, you really shouldn't as you're multiplying over a million values by over a million cells.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
thanks tms
is there anyway i can get the highest number to auto populate?
ie
if after i update next weeks records and there is 36 it should change to 36?
kind regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks