Summary Page

[inactiveuserps13]

Hi Guys!

how do you summarise data from several worksheets containing specified data?

I have the following information on several tabs under same columns and I would like this to link to a summary page so that I can clearly see a count on each period and week number:

I have 4 columns:

Column A - Period
Column B - Week
Column H - Available Records (Count)
Column I - Unavailbale Records (count)

Any ideas?

 

[Jared_8878]

Is each tab for a different product?
If so just enter the formulas that point to each sheet on the summary page.

so on the summary page you would use a countif or countifs (as you mentioned counting) for each of your sheets.

If that is not it, perhaps some more detail would help.

 

[inactiveuserps13]

Hi, Yes each sheet is for a different product, what would the formula be to summarise each sheet on a Summary sheet?

 

[ADAMC]

Hi

As Jared suggested looks like countif(s) sumif is probably the way to go but difficult to tell without some more detail.

Can you provide some sample data of exactly what is in columns A/B/H/I....

Should make it easier to answer your question.

cheers

 

[inactiveuserps13]

Hi ADAMC,

(Column Title -Period)
In Column A = 4

(Column Title -Week)
In Column B = 1

(Column Title -Available records)
In Column H = 200 (Count whatever number of records is entered)

(Column Title - Unavailbale Records
In Column I = 55 (Count whatever number of records is enetered)

hope this help?

 

[Jared_8878]

so if you are on office 2007 or greater

in your summary sheet it =countifs(
you can see the order of the formula it goes
range
,
criteria

so after =countifs( click on the sheet you want to count and click the column, hit comma then type in your criterial, and continue on in that fashion till you are done.

for example =countifs(sheetnameA:A,4,sheetnameB:B,1,.......

 

[inactiveuserps13]

2003 unfortunately Guys!

 

[Jared_8878]

then you will need an array formula

=count(if((sheetnameA:A=4)*(sheetnameB:B=1),sheetnameH:H))

confirmed with ctrl+shift+enter