Array formula in numbers
Imported from the Apple Support Forums via the Wayback Machine 🔗
Hi everyone,
I'm fairly new to Numbers and wanted to create an array formula in it. I read that this is not supported and one has to work around it.
I'm trying to achieve the below:
The formula is supposed to sum across column C if there is an x in column I and divide each amount in column C by the number of people, unless the person in row 1 matches the person in column E.
In the example (I14) the formula should sum I2:I6 and divide each entry by 8 (amount of people in column G). Since Anne did not pay anything (column E), nothing is subtracted from that amount.
Can anyone point me in the right direction? Thanks.
3 replies
Sign in or join Beachball Help to reply.
- 0
- 0
- 0