## [Solved] Formula help - SUMIF or SUMPRODUCT

### [Solved] Formula help - SUMIF or SUMPRODUCT

Hi

I am a beginner when it comes to formulas / functions. I am trying to make a spreadsheet that gives me the total value of all orders due in within 30 days, within 60 days and within 90 days.

I have a column that shows the number of days until an order is due, and the column next to it shows the value of the order. I want the sum of all orders where the number of days until due is less than 31 and the same for 61 and 91.

I have tried using SUMIF or SUMPRODUCT functions but can't figure it out. I may need some helper columns, not sure. I have the example 'aggregate' spreadsheet but still can't figure it out, duh!

I'm wondering if one of you can delve into the infinite depths of your knowledge and expertise and enlighten me! I am eager to learn. I have attached an example of what I'm trying to do.

Jonathan
Win XP SP2, OOo 2.4
Attachments
sample.ods
Last edited by jonsoellner on Fri May 16, 2008 2:00 pm, edited 1 time in total.
jonsoellner

Posts: 20
Joined: Mon Jan 07, 2008 1:34 pm
Location: Exeter, Devon, UK

### Re: Formula help - SUMIF or SUMPRODUCT

Just another example demonstrating some options (I forgot subtotals).
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4

Villeroy
Volunteer

Posts: 29107
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

### Re: Formula help - SUMIF or SUMPRODUCT

Done! Thanks Villeroy you are very helpful.
jonsoellner

Posts: 20
Joined: Mon Jan 07, 2008 1:34 pm
Location: Exeter, Devon, UK

### Who is online

Users browsing this forum: No registered users and 23 guests