How do I sum cells for a certain month?

M

Mark Jackson

Hello,

I am using this formula
=SUMPRODUCT(--(MONTH(Gateway!B3:B26)=1),--(YEAR(Gateway!B3:B26)=2005),--(ISNUMBER(Gateway!B3:B26)))which
works fine. Based on this formula how can I sum the dollar value in column J
for the month of January? Your help is appreciated.

Mark
 
A

Amy O

I might be misunderstanding, but if you want to get totals by month the best
way might be a pivot table. Selecting all data in the sheet (including
column headers), go to data->pivot table and follow the wizard, (next, next,
finish). Then drag the date column heading from the pivot table field list
to the row fields area and the money column heading from the pivot table
field list to the data items area. If you right-click on the date column
heading on the pivot table, you can choose to group them by month and year.
 

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

Multi area Array using IRR function 2
formula finds values in apparently blank cells 1
VLOOKUP over three spreadsheets 8
How do i return data in a cell from the referred cell? 2
sun results of a vlookup across a range 3
Stop Macro running when I save the workbook 1
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
IF(AND(OR function returns #VALUE! error 3

Top