I think I'm missing something obvious but I don't know what to Google, I've had quite a look around. I have a list of data some of which is collated with IFS and then moved onto another sheet with QUERY. I want to add it up to put it in a caseload calculator, but I can't get the sum formulas to work, on either version of the data. I've done a quick mock up here, is there something I should be aware of with formulas returning plain text, or wrapping things up in number formats? I can't copy paste as values only because they'll potentially change.

CodePudding user response：

try:

=INDEX(SUM(1*B2:B))

or:

=SUMPRODUCT(B2:B)