View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Robbo12 Robbo12 is offline
external usenet poster
 
Posts: 3
Default Urgent assistance required for excel

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