totalling by date renge

[mon]

I have lists if income by date and list of expenses by
date. How can I make a total of say all income in
september minus the expenses for september?
Thanks Mon

 

[Candice Mesk]

Send me the spreadsheet and maybe i can help you.

 

[Norman Harker]

Hi mon!

Here's the basics of summing by Month:

A1:A200 Contains dates.

In D1

=MONTH(A1)

Copied down



=SUMIF(D$1$200,=E1,B$1:B$200)

Returns the sum of entries in B1:B200 where the number in the
corresponding row in column D equals the number in E1.



But if we want to put the value in the formula we need to use:

=SUMIF(D$1$200,"="&10,B$1:B$200)



Note the quotation marks around the = and the use of & to join it with
the value we are using.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Don Guillett]

this should give you the idea.
=sumproduct((month(a2:a200)=9)*b2:b200) where b2:b200 has the income