• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sum data

F

F8MS

New Member
I need to sum accounting data where the accounts are identified by a nominal code no. between a data range.

Assuming I have the following:

account no. A1:A10 (e.g. phone, rent etc)

value B1:B10

booking dates C1:C10 (e.g. from 01.04.12 to 30.06.12)

I know I can use sumif(A1:A10,rent,B1:B10)

I know how to use sumifs to sum values between range dates,

How can I combine them together (e.g. sum all 'rent entries' for period from 01.05.12 to 31.05.12


Thank you
 
If you can already use SUMIFS, just add the rent entries as another criteria.

=SUMIFS(B1:B10,A1:A10,"rent",C1:C10,">="&LowerDate,C1:C10,"<="&UpperDate)
 
F8MS


Firstly, Welcome to the Chandoo.org forums.


You may want to read: http://chandoo.org/wp/2010/04/20/introduction-to-excel-sumifs-formula/
 
You must log in or register to reply here.
Back
Top