summing up figures
hello again.
i would like to know how i can get excel to sum up figures from a set date only. i have column A with the date and column F with transactions values and i want excel to be able to take only the figure from a certain date and give me the figures for just that date. for example sheet1 is containing figures for whole of november with the date in column A i want excel to show on sheet3 a totals for the figures in column F under the appropriate date. thank you. -- - Rich |
summing up figures
=SUMPRODUCT(--(A2:A20-DAY(A2:A20)+1=--"2005-11-01"),F2:F20)
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Rich" wrote in message ... hello again. i would like to know how i can get excel to sum up figures from a set date only. i have column A with the date and column F with transactions values and i want excel to be able to take only the figure from a certain date and give me the figures for just that date. for example sheet1 is containing figures for whole of november with the date in column A i want excel to show on sheet3 a totals for the figures in column F under the appropriate date. thank you. -- - Rich |
All times are GMT +1. The time now is 03:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com