Urgent assistance required for excel

[Robbo12]

Hi there
I really need help.
I have a spread sheet in which has weekly summaries. Each weekly summary is
the same but i need to add up the monthly totals.
For example A1 = Cow. Below say A10, A30 and A50 have Cow with a total in
column B. How can i return a count of all Cow when a Vlookup for example
stops looking after the first Cow it comes to. Is there a formula i can use
to have Vlookup add all the data in the Range if it includes more then 1
Range lookup??

 

[Per Jessen]

Hi

I think you need CountIF and SumIF functions:

=CountIf(A1:A100,"Cow")

=SumIf(A1:A100,"Cow",B1:B100)

Hopes this helps.
....
Per

 

[Iriemon]

Sounds like you need a Pivot Table.

Irie!