Urgent assistance required for excel

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top