Urgent assistance required for excel

  • Thread starter Thread starter Robbo12
  • Start date Start date
R

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??
 
Hi

I think you need CountIF and SumIF functions:

=CountIf(A1:A100,"Cow")

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

Hopes this helps.
....
Per
 
Back
Top