LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 5
Default sum columns only if date

Hi, I need a little help with this function.

I have dates in column A (3/31/12), an categories in column B (maintenance) and then a dollar amount in column C ($52.55).

I would like a function that would sum the dollar amounts only if the date was in March and the catagory matched "maintnenance"

Any help?

Thanks,

David

Last edited by dkte737 : June 10th 12 at 02:43 PM
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for determining if two date columns fall within specific date range Igottabeme Excel Worksheet Functions 2 April 21st 06 02:50 AM
Formula for determining if two date columns fall within specific date range Igottabeme Excel Discussion (Misc queries) 1 April 20th 06 10:03 PM
formula to look up a date and add x, y, z columns to x, y, z row Sally J Excel Worksheet Functions 1 December 7th 05 03:08 AM
excel formula counting date to date in 4 columns stuie d Excel Worksheet Functions 1 May 4th 05 12:46 PM
DATE SORT BY COLUMNS Sue Excel Worksheet Functions 0 January 13th 05 06:03 AM


All times are GMT +1. The time now is 01:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"