| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count data in 2 columns
Thanx for the assistance. This worked for me - =SUMIF(A:A,"John Doe",B:B) This didn't - =sumproduct(--(A1:A500)="John Doe"),--(B1:B100)) If "John Doe" is in a cell e.g C1, then replace literal by cell =sumproduct(--(A1:A500)=C1),--(B1:B100)) When I used these, I kept getting the #VALUE! error. My list of names is in A2:A60, the corresponding numbers are in B2:B60. I'm using Excel 2003. Thanx -- Ltat42a ------------------------------------------------------------------------ Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735 View this thread: http://www.excelforum.com/showthread...hreadid=546477 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Only count columns if the column next to it is not blank | Excel Discussion (Misc queries) | |||
| MATCH UP DATA IN COLUMNS | Excel Worksheet Functions | |||
| how do I lookup data based on two columns of data | Excel Worksheet Functions | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
