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: 4
Default SUMIFS-time criteria/month

Hi all!

I have a sheet where i have
Column A: orders
Column B: date of the order
Column C:Type of product
Column D:Amount


I want to SUM the amount (D) of some of the type of products (xD) per month
(B).

My collumn B has dates in the following format : DD-MM-YYYY

Could anyone help me how to write the function? how should i write it in
SUMIFS function in order to calculate only the orders i got for the product
type X per months?

Any idea? Any other function maybe??

Thanks in advance







 
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
SUMIFS with an OR criteria Go Bucks!!![_2_] Excel Worksheet Functions 8 September 17th 09 09:30 PM
using sumifs with multiple criteria? Celia Excel Discussion (Misc queries) 3 April 8th 09 02:14 AM
sumifs criteria Ebisu-A Excel Worksheet Functions 3 August 25th 08 08:24 PM
SUMIFS with 3 criteria instead of just 2 Hopper Excel Worksheet Functions 1 August 20th 08 07:59 PM
using sumifs to sum based on month, and criteria Jonas Excel Worksheet Functions 13 April 29th 08 01:12 PM


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