totalling by date renge

  • Thread starter Thread starter mon
  • Start date Start date
M

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
 
Hi mon!

Here's the basics of summing by Month:

A1:A200 Contains dates.

In D1

=MONTH(A1)

Copied down



=SUMIF(D$1:D$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:D$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.
 
this should give you the idea.
=sumproduct((month(a2:a200)=9)*b2:b200) where b2:b200 has the income
 
Back
Top