Sum IF

[omer123456]

Hi,

How can I extract all the values ..........see example attached (better formatting)

YES SOME OF THE DATES HAVE TIME IN THEM and I am not sure how to extract just date too :-(

Thanks for all your help
Omer


Yes/NO

11/14/13 Apples 21-781 1
11/14/13 Banana 21-782 1
8/1/14 Banana 21-783 1
1/4/13 Pineapple 68-946
11/14/13 Celery 68-947
11/14/13 Oranges 66-108
1/6/12 Apples 66-109
11/14/13 Oranges 34-771
11/14/13 Banana 34-772
11/14/13 Oranges 34-773
12/31/14 Apples 68-948
11/14/13 Banana 68-949
11/14/13 Pineapple 21-780 1
6/1/13 Pineapple 21-785 1
8/1/12 Apples 21-786 1

Would like the following results from the table above

From To Desc 2012 2013 2014

1/1/2012 12/31/2012 Apples 1 1
1/1/2013 12/31/2013 Bananas 1 1
1/1/2014 12/31/2014 Oranges
Pineapple 2

[Pepe Le Mokko]

A Pivot Table seems to be doing the trick

[jayajaya_4]

ur expected reults are bit confusing as 1/1/2012 12/31/2012
1/1/2013 12/31/2013
1/1/2014 12/31/2014
are not available above...need clarifications on it??

[omer123456]

The dates are there my friend........ For clarification

I want to see how many apples I bought in the year 2012, 2013, 2014.................& then within 2012 How many in the month of Jan, feb, mar.....etc

Thanks

[Pepe Le Mokko]

See my post. You can group a Pivot Table per month AND per year

[omer123456]

Pepe,

There is only "6" items I bought ( The ones with 1 in column D).......So Grand total in you pivot table cannot be more then 6 (Its showing 15) :-)

Also, can this be done without pivot table............or you are gonna have to give me instructions for my 42000 entries I have in my table.

THANKS FOR TRYING AND HELPING ME

[omer123456]

Pepe,

Only count apples if there is a "1" in column D :-)..........Then how many per year and month

THX

[Pepe Le Mokko]

Better like this?

[omer123456]

YOU THE MAN PEPE.


Now send me some basic instructions so I can do it for my 42,000 entries

Thanks
Omer

[Pepe Le Mokko]

First add headers to your columns
Select a cell in the table
Go to the Insert ribbon - Select Pivot Table and follow the wizard to obtain the same layout as I showed

[omer123456]

Thx Pepe....I will try this afternoon

[Pepe Le Mokko]

If you still use 2003 it might be a bit different, but it's rather self explanatory
There is some help at http://www.contextures.com/xlPivot02.html