Need formula to sum

G

Guest

I have a database with the following columns: store number, date (YMD) &
costs. The database covers several years. I need a formula to sum all costs
for a any particular store and for each month.

example: What is the sum of all costs for store 2143 for the month of Jan
in 06?

2143 1/2/06 27.50
2143 1/5/06 84.75
2143 4/5/06 47.50
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional sum equals 0 4
Find last column matching criteria 2
sumif for months and year 2
Condition Sum 3
How do I sum between any two entered values in a vlookup table 4
sumtotal as per date range 4
how to sum with this table 8
Need to transform the dates to months 4

Top