ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Sum the time for a criteria in a range. (https://www.excelbanter.com/excel-programming/309006-sum-time-criteria-range.html)

Rene

Sum the time for a criteria in a range.
 
I would like to look back the last 90 days in a "a"column after entering a
specific date.
In that range I would like to add flight times "c"column for a specific
criteria "b"column.
How do I put this in a formula. Is it possible at all?

Frank Kabel

Sum the time for a criteria in a range.
 
Hi
see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards
Frank Kabel
Frankfurt, Germany


Rene wrote:
I would like to look back the last 90 days in a "a"column after
entering a specific date.
In that range I would like to add flight times "c"column for a
specific criteria "b"column.
How do I put this in a formula. Is it possible at all?



All times are GMT +1. The time now is 05:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com