xl2bb formula summary errors.

[jasonb75]

Anyone else experiencing this problem?

I've just used xl2bb to show some results in a reply, there are 2 completely different formulas in use but the formula summary is saying that there is a common formula covering the entire range. (see link below)

Sumifs array...

Hello experts, What formula can I use to get the value: Name 1-Feb-20 3-Feb-20 10-Feb-20 20-Feb-20 01-Mar-20 Cups 2 5 8 7 12 Spoons 3 1 7 9 8 Cloth 6 3 4 5 11 Plate 10 5 2 4 14 Need to have: Name Date Total numbers beyond the given date Cloth 3-Feb-20 Cups 1-Feb-20...

www.mrexcel.com

Summary shows one formula covering C8:D10. If you hover over the cells, you will see that C8:C10 contain the formula shown, but D8:D10 contain the formula that I've added below the table.

 

[Fluff]

Which version are you using? 1.2.5 or 1.2.6
With 1.2.6 it works for me.

ZFluff.xlsm
	A	B	C	D	E	F
1	Name	########	########	########	########	########
2	Cups	2	5	8	7	12
3	Spoons	3	1	7	9	8
4	Cloth	6	3	4	5	11
5	Plate	10	5	2	4	14
6
7	Name?	Date?	1 way	another way
8	Cloth	########	20	20
9	Cups	########	32	32
10	Plate	########	18	18
Main

Cell Formulas
Range	Formula
C8:C10	C8	=SUMPRODUCT(($A$2:$A$5=$A8)*($B$1:$F$1>$B8)*$B$2:$F$5)
D8:D10	D8	=IFERROR(SUM(INDEX(INDEX($B$2:$F$5,0,MATCH($B8,$B$1:$F$1)+1):$F$5,MATCH($A8,$A$2:$A$5,0),0)),0)

 

[MARK858]

I get the same result as Fluff with 1.2.6

 

[jasonb75]

Where do I find version number, guys? Project explorer shows XL2BB120 does that mean version 1.2.0?
Freshly downloaded onto new laptop no more than 24 hours ago, maybe just really bad timing?

Just tried it again in case it was some kind of error on my part, copied the bb code here and previewed, exactly the same. with both the original workbook and a newly created blank.

Perhaps it works with 365 but not 2019
I'm going to remove the add-in and download it again, see if that fixes it.

 

[MARK858]

When you click Capture Range the version is in the top banner (at least it is in 1.2.6 I can't remember if it was there in the earlier versions). I think it was only updated to 1.2.6 this morning UK time.

 

[jasonb75]

Thanks, Mark!

I just checked it and I do have v1.2.0 Time for an update.

edit:- updated to v1.2.6 and all problem solved.

Thanks guys.

 

[Fluff]

Glad it's sorted & thanks for letting us know

 

[Marcelo Branco]

Array formula in column E is not appearing in the box Cell Formulas - only formulas in column F
XL2BB Version 1.2.5


See

Football result outcome.

Hi, I am looking to find a formula to find the expected result comparing previous second half scores with the first half score Which is the most likely result. e.g. HT FT 0-0 0-0 0-0 3-1 0-0 0-0 0-0 0-0 0-0 2-2 0-0 2-0 0-0 0-1 0-0 1-0 0-0 1-1 0-0 0-0 0-0...

www.mrexcel.com

M.

 

[Fluff]

That has been fixed in the current version 1.2.6

 

[Marcelo Branco]

That has been fixed in the current version 1.2.6

Thanks. Working now!
Version 1.2.6

M.