Simple Array

M

Marilyn

Hello
I have 30 columns with this formula =A1-SUM(A2:A27) WOuld like to convert
this into an array formula. this is my formula ={A1:D1-SUM(A2:D27)} then
control+shift+enter but the results are wrong (the sample only cover 4
columns)
what's wrong? Thanks
 
P

Peo Sjoblom

What are you trying to do,assume that SUM(A2:D27) = 200

A1:D1 holds 100, 100, 100 and 100

what is your expected result?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ISODD array formula 1
Dynamic Sum Array Formula Input Help 3
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
up and down array 7
How to use Sumifs with vertically and horizontally criterias 1
Array Constant 3
Array reference 3
hlookup in array 2

Top