B
bee
I have the following columns in a worksheet
A B C D E
DATE ITEM COST TAX TOTAL COST
28/04/07 LAYING PIPE $50.00 $5.00 $55.00
THROUGH TO
6/5/07 LAYING PIPE $50.00 $5.00 $55.00
can excel calculate the total cost for any period for example say from
28/04/07 to 06/05/07. I have treid sumif and vlookup but cannot get a formula
to calculate between the dates specified.
Is there a formula that I could use to calculate from and to or between dates.
thank you for your advice.
A B C D E
DATE ITEM COST TAX TOTAL COST
28/04/07 LAYING PIPE $50.00 $5.00 $55.00
THROUGH TO
6/5/07 LAYING PIPE $50.00 $5.00 $55.00
can excel calculate the total cost for any period for example say from
28/04/07 to 06/05/07. I have treid sumif and vlookup but cannot get a formula
to calculate between the dates specified.
Is there a formula that I could use to calculate from and to or between dates.
thank you for your advice.