| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Urgent assistance required for excel
Hi
I think you need CountIF and SumIF functions: =CountIf(A1:A100,"Cow") =SumIf(A1:A100,"Cow",B1:B100) Hopes this helps. .... Per On 12 Jan., 00:30, Robbo12 wrote: 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?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Urgent assistance required for excel
Sounds like you need a Pivot Table.
Irie! "Robbo12" wrote: 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?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| URGENT HELP REQUIRED - EXCEL LOADS WITHOUT ANY COMMAND BARS AN | Excel Discussion (Misc queries) | |||
| URGENT ASSISTANCE | Excel Discussion (Misc queries) | |||
| Assistance required | Excel Discussion (Misc queries) | |||
| Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
| excel page breaks - urgent help required | Excel Worksheet Functions | |||
Linear Mode
