Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing up figures
Have a look at the SUMIF and COUNTIF functions in help index
-- Don Guillett SalesAid Software "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing positive figures to minus figures | Excel Worksheet Functions | |||
Formula to strip figures from cells text strings | Excel Discussion (Misc queries) | |||
calculate minus figures | Excel Discussion (Misc queries) | |||
calculate minus figures only | Excel Discussion (Misc queries) | |||
Calculate minus figures only | Excel Discussion (Misc queries) |