We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

how do I distribute an operation across a range of cells? [closed]

asked 2018-06-12 00:33:07 +0200

garydale gravatar image

updated 2021-05-23 01:19:40 +0200

Alex Kemp gravatar image

I have a spreadsheet which I use to track deliveries and sales to calculate the cost and profits for a small range of items. I have the items described in columns so that the column head has the item description, the next row has its price, then the cost, and finally the calculated unit profit.

Below that I have the various deliveries of that item (i.e. the number of that item delivered on a date) followed by the sales (again by date or date range).

I want to be able to calculate the gross sales ($), for example, of a delivery or sale by a formula that would take range of columns and apply the same operation to each cell. For example, to take C2 (the price) * C23 (the number sold that day) and do it across columns such B to R to produce the total price of all goods sold that day.

I've tried googling the answer but I can't even think of a good set of search terms. I think I'd have to know the answer to ask the question. :(

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2021-05-23 01:19:58.822630

1 Answer

Sort by » oldest newest most voted

answered 2018-06-12 00:48:09 +0200

garydale gravatar image

Ok, got it. SumProduct seems to do what I want.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-06-12 00:33:07 +0200

Seen: 68 times

Last updated: Jun 12 '18