Adding muliple sum formulas in one column

Closed
Noah - Nov 16, 2009 at 12:07 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 16, 2009 at 08:51 PM
Hello,
I have a spreadsheet which I converted from a PDF report with thousands of orders each of which have either single line items or multiple line items. The total for each line item is in column D and I would like to get a sum for each order and need to know what formula or macro I could enter rather than going to each cell and clicking autosum for the order range above.

For example range D3:D5 has dollar amounts for one order and D6 has #N/A, D7:D12 has dolalrs amounts for another order and D13 has #N/A, D14 has a dollar amount and D15 has #N/A. The list goes on and on.

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Nov 16, 2009 at 08:51 PM
I suggest the following.
first in the same sheet or in separate sheet
list the unique order names by using advance filter
then you can use COUNTIF function or SUMPRODUCT function. read
help on these fucntions and also advance filter method.
0