LinkBack URL
About LinkBacks
Morning,
Please see attached worksheet, Sheet 2> Column E> for some reason SUMPRODUCT formula is only working in one cell (highlighted), any ideas? I'm probably missing something obvious!
Many thanks
Jason
VSum-test.xls
Morning,
Please see attached worksheet, Sheet 2> Column E> for some reason SUMPRODUCT formula is only working in one cell (highlighted), any ideas? I'm probably missing something obvious!
Many thanks
Jason
VSum-test.xls
Yep, your numbers are stored as text, if you convert them to numbers, the formulas work
Or you can convert your lookups in sheet 2 to text
VSum-test.v2.zip
Apologies I attached the incorrect worksheet....Lookups are custom due to Mode formula in attached...
Thanks
Jason
Hi Jason,
They're still formatted as text, this is proved by the fact that this works for 1085. Only 1097 is stored as a number on the first sheet
PHP Code:=SUMPRODUCT(--(TEXT($A4,"####")=Sheet1!$A$2:$A$13210),--(E$2=Sheet1!$D$2:$D$13210),Sheet1!$B$2:$B$13210)
Last edited by Kyle123; 01-31-2012 at 07:40 AM.
Thanks Kyle, help is much appreciated....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks