ExcelBanter - View Single Post

Teethless mama

Here is the link

http://www.4shared.com/file/11556675...ca57/Data.html

"Teethless mama" wrote:

PIVOT table is an easy way to analyze your data

"Artamas" wrote:

I am pulling information off two different documents to try and creat
conditional values in the current spreadshet(Daily Store Totals). I am trying
to pull information off of the Daily Customer Totals. The sheet is a
continuous listing by date of all information:
A B C

1 DATE STORE CODE Customer
2 5/30/09 601 John Smith
3 6/1/09 813 Joe Black
4 6/1/09 724 Jim Chang
5 6/1/09 619 Jerry Fiest
6 6/1/09 813 Steven Calhoon

I am trying to count how many applications were submited by the store code
on each day. So I am trying to make a conditional function in the new
spreadsheet:

A B C D
E
1 Date | 6/1/09
|
2 Store Code | Total App Rec | Den | Pen | Apr |
3 601 =Function?
4 619
5 724
6 813

I am running 2003 excell and cant wrap my head around how to format the
function, i was trying to do =IF('[Daily Customer Totals]Sheet
1'!$B:$B=A3,IF('[Daily Customer Totals]Sheet 1'!$A:$A=B1, SUMIF('[Daily
Customer Totals]Sheet 1'!$B:$B, A3, .......... or somthing along those lines.
Please help!