Excel formulas
Closed
ybaudier
-
4 Oct 2010 à 23:54
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 5 Oct 2010 à 06:43
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 5 Oct 2010 à 06:43
Related:
- Excel formulas
- Excel mod apk for pc - Download - Spreadsheets
- Formula to calculate vat in excel - Guide
- Number to words in excel formula - Guide
- Kernel for excel repair - Download - Backup and recovery
- Grade formula in excel marksheet - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
5 Oct 2010 à 06:43
5 Oct 2010 à 06:43
suppose sample data from 1 to B11 is like this
date amount
12/25/2009 3460
12/26/2009 2427
12/27/2009 3164
12/28/2009 1498
12/29/2009 2506
12/30/2009 5838
12/31/2009 491
1/1/2010 6589
1/2/2010 4743
1/3/2010 9254
now in any empty cell cell copy this formula
=SUMPRODUCT((A2:A11>DATEVALUE("12/31/09"))*(B2:B11>5000)*(B2:B11))
you will get 15843
you can use any combination in the formula.
modify a11 and B11 depending upon the length of the data.
date amount
12/25/2009 3460
12/26/2009 2427
12/27/2009 3164
12/28/2009 1498
12/29/2009 2506
12/30/2009 5838
12/31/2009 491
1/1/2010 6589
1/2/2010 4743
1/3/2010 9254
now in any empty cell cell copy this formula
=SUMPRODUCT((A2:A11>DATEVALUE("12/31/09"))*(B2:B11>5000)*(B2:B11))
you will get 15843
you can use any combination in the formula.
modify a11 and B11 depending upon the length of the data.
