Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding the MAX number while considering similar names
Hello!
I have a list of names associated with hours. I want to get the maximum hour number while adding whatever hours of the same names. Here is an example of a sheet: a 2 b 5 a 1 a 6 d 3 Visually, I know my answer is: 9 Because since "a" is the same person, that persons hours gets added. And so the maximum number is no longer 6, but an addition of all the similar names. In this case, "a" which gives me 9. I hope I wasn't too confusing... thanks in advance for the help!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding the MAX number while considering similar names
Try this:
=SUMIF(A1:A5,"A",B1:B5) Biff "Ninjapowa" wrote in message ... Hello! I have a list of names associated with hours. I want to get the maximum hour number while adding whatever hours of the same names. Here is an example of a sheet: a 2 b 5 a 1 a 6 d 3 Visually, I know my answer is: 9 Because since "a" is the same person, that persons hours gets added. And so the maximum number is no longer 6, but an addition of all the similar names. In this case, "a" which gives me 9. I hope I wasn't too confusing... thanks in advance for the help!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding the MAX number while considering similar names
Perhaps
=MAX(SUMIF(A1:A5,A1:A5,B1:B5)) array entered with Cntrl+Shift+Enter (or you get #VALUE) "Ninjapowa" wrote: Hello! I have a list of names associated with hours. I want to get the maximum hour number while adding whatever hours of the same names. Here is an example of a sheet: a 2 b 5 a 1 a 6 d 3 Visually, I know my answer is: 9 Because since "a" is the same person, that persons hours gets added. And so the maximum number is no longer 6, but an addition of all the similar names. In this case, "a" which gives me 9. I hope I wasn't too confusing... thanks in advance for the help!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding the MAX number while considering similar names
small correction - if it's not array entered you get 0 (although normally I
get and have come to expect #VALUE) "JMB" wrote: Perhaps =MAX(SUMIF(A1:A5,A1:A5,B1:B5)) array entered with Cntrl+Shift+Enter (or you get #VALUE) "Ninjapowa" wrote: Hello! I have a list of names associated with hours. I want to get the maximum hour number while adding whatever hours of the same names. Here is an example of a sheet: a 2 b 5 a 1 a 6 d 3 Visually, I know my answer is: 9 Because since "a" is the same person, that persons hours gets added. And so the maximum number is no longer 6, but an addition of all the similar names. In this case, "a" which gives me 9. I hope I wasn't too confusing... thanks in advance for the help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Names | Excel Worksheet Functions | |||
Finding number of particular days in a period | Excel Worksheet Functions | |||
Finding the 3rd largest number in a list | Excel Worksheet Functions | |||
Finding First and Last Worksheet Names | Excel Discussion (Misc queries) | |||
finding row number? | Excel Discussion (Misc queries) |