View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mctabish[_2_] Mctabish[_2_] is offline
external usenet poster
 
Posts: 3
Default Creating a budget from a list of transactions

I have a list of purchases/payments. I would like to create a spreadsheet
that will break these down by payee and month. I know that if I want to get
either month OR payee, I can use sumif, but how do I break it dow by month
AND payee?

Here is my PAYEE breakdown: =SUMIF('bussiness
expenses'!B$2:B$138,A2,'bussiness expenses'!D$2:D$138) With PAYEE being in
column A on current sheet, and column B for the lookup.
My transaction date is in column A on bussiness (I know I have business
mis spelt, but...)

How would I do this?

Thanks