Results 1 to 2 of 2

Thread: SUM of expenses per month

  1. Dec 2nd, 2004, 05:01 AM #1
    karambos
    karambos is offline

    Thread Starter
    New Member
    Join Date
    Nov 2004
    Posts
    11

    SUM of expenses per month

    I have a worksheet where column A is the date (in format 01-Jan-2004), column C is the amount spent and column D is what is was spent on.

    I would like to find out how much was spent on food each month, how much on travel etc. So I need to be able to say

    Where column A = November 2004 AND column D = "Food" SUM all numbers in column C

    But I'm a novice at Excel. Would this best be done by writing a function in visual basic or is there a quicker way to do it?

    Thanks for any help
    Reply With Quote Reply With Quote
  2. Dec 2nd, 2004, 06:58 AM #2
    David.Poundall
    David.Poundall is offline
    Frenzied Member David.Poundall's Avatar
    Join Date
    Sep 2002
    Location
    Robin Hood Land
    Posts
    1,457
    You may get more help on this one in the VBA forum :-)
    David

    Learn the Rules so that you know how to break them properly.

    Printing dll dBTools MZTools Winsock API WinsockVB More Winsock SGrid2 MSChart Mail2Web

    If you have found this thread useful then read this
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width