Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
John K
Lv 5
John K asked in Computers & InternetProgramming & Design · 1 decade ago

How can I make open office calc (basically excel) give me a total based on a date range?

I want a total of all the figures from columns C through F but only from a date range from a date in column b.

My formula so far..

=SUMIF(B2:B9999,"<"&DATE(2008,12,31),C1:F9999)-SUMIF(B2:B9999,"<"&DATE(2009,1,31)) ,C1:F9999)

or

=SUMPRODUCT((B2:B9999>=DATE(2009,1,1)),(B2:B9999<=DATE(2009,1,31)),C1:F9999)

Update:

Let me know if the answer is for a formula or an array

1 Answer

Relevance
  • Michael E
    Lv 7
    1 decade ago

    =SUMPRODUCT( --(startDate<=B1:B100) , --(B1:B100<=endDate), C1:C100 + D1:D100 + E1:E100 + F1:F100)

Still have questions? Get your answers by asking now.