View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duncan Duncan is offline
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