LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 26
Default Multiple Criteria for SUMIF

Hello,
I'm having issues trying to sum data using more than a single criteria.
My layout is as such;
Col.A = Date
Col.B = Type
Col.C = Note
Col.D = Value

I am trying to sum all the Values within a single month (Jan, Feb, etc) of a
single type (Rent, Misc, Ent, etc).

I would also like to query the last 90 days (NOW()-90) for each Type.

What would be a good formula for these?

Thanks in advance.
--
<Insert witty comment here
 
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
SUMIF WITH MULTIPLE CRITERIA? kahuna Excel Worksheet Functions 5 October 2nd 07 06:05 PM
Sumif with multiple criteria tina Excel Discussion (Misc queries) 4 February 2nd 07 09:10 PM
Sumif with multiple criteria jn77 Excel Worksheet Functions 5 July 19th 06 09:52 PM
SUMIF With Multiple Criteria Mike Excel Worksheet Functions 1 November 2nd 05 11:08 PM
Sumif - multiple criteria Anat Excel Discussion (Misc queries) 1 July 14th 05 03:01 AM


All times are GMT +1. The time now is 11:12 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"