I'm having difficulties finding a way to create the following type of formula:
=sumif("A" & begin, "A" & end; "A" & end +2; "B" & begin, "B" & end)
I tried FORMULA= instead of FORMULAR1C1= but cannot get beyond the quotation marks.
Is it possible at all? I found no examples.
Thanks
=sumif("A" & begin, "A" & end; "A" & end +2; "B" & begin, "B" & end)
I tried FORMULA= instead of FORMULAR1C1= but cannot get beyond the quotation marks.
Is it possible at all? I found no examples.
Thanks