Muthukrishnan V
Active Member
- Joined
- May 29, 2008
- Messages
- 297
- Office Version
- 365
- Platform
- Windows
Microsoft Excel 2007:
I have the following formula in J45, which gives wrong answer as 0.
=SUMIFS(D5:D33,C5:C33,">="&H40,E5:E33,"<="&H41,G5:G33,"TaxSave")
D5:D33 Amount in numericals
C5:C33 Start date in dd-mm-yyyy format
E5:E33 End date in dd-mm-yyyy format
G5:G33 Text msg, (example: Current Old TaxSave)
H40 Helper with Start date (example 01-04-2018)
H41 Helper with End date (example 31-03-2019)
End date is greater than Start date.
In my worksheet I have text TaxSave in G14 only.
Kindly correct the formula suitably.
Thanking you,
I have the following formula in J45, which gives wrong answer as 0.
=SUMIFS(D5:D33,C5:C33,">="&H40,E5:E33,"<="&H41,G5:G33,"TaxSave")
D5:D33 Amount in numericals
C5:C33 Start date in dd-mm-yyyy format
E5:E33 End date in dd-mm-yyyy format
G5:G33 Text msg, (example: Current Old TaxSave)
H40 Helper with Start date (example 01-04-2018)
H41 Helper with End date (example 31-03-2019)
End date is greater than Start date.
In my worksheet I have text TaxSave in G14 only.
Kindly correct the formula suitably.
Thanking you,