Hello,
I am having a real problem with an Excel formula.
I have a worksheet with variable rows and a number of columns. I need to add together the values of particular cells in one column, but only if corresponding cells in another column fit within a date range. I need to do this for all rows (although I won't know how many rows there are until I have imported the data), and for different date ranges. I need to add the values together on a seperate sheet.
The reason for this is that I want to sort activity put through a particular account into weeks. The data is input with a date, but i need all data up to and including the week end to add together to give me the week's total. I need to do this for each week of the year.
I have tried =IF(AND(criteria<range,range<=criteria),cell,), but realised that I would have to re-type this for each row. There could be as many as 400 rows, and never less than 110.
Any help would be appreciated.
Thank you
Dominic
Configuration: Windows Vista Safari 530.5
Supose your data is A1 to B15 like this
|
2 ip addresses on one computer Add data to next blank cell in excell vba Adding two hard drives with one sata connection Copy data from one excel to another Data by column Excel alternate column copying data Excel count if one column equals a set criteria in another column Excel formula to sum and sub in one column Excel same data in column a and column b which row How data pass from one computer to another physically ? How to add data form different spreadsheets How to transfer data through ip address from one system to another Merge multiple cells to one cell column Merge multiple cells to one column Multiple cells to one cell column Transfer data from one computer to another file sharing Use data from one cell plus text numbers What if mac address access point different than the one on modem