![]() |
#1
|
|||
|
|||
![]()
hi,
In columns A, C and E have names (names are not always same in all three coulmns). In columns B,D and F i have values. I would like to SUM that values for users in columns A, C and D. So if I have A: Tony Parker, B:2, C:Tony Parker, D:1; E: TOny parker; F:0 > sum is 3 BR |
#2
|
|||
|
|||
![]()
For example:
=SUMIF(A1:F1,"<"&9^9) |
#3
|
|||
|
|||
![]()
hello
thanks for respons, why is there "<"&9^9? BR |
#4
|
|||
|
|||
![]()
Just some very big number.
Try to enter for example: =9^9 < "Z" Last edited by xor; 01-30-2016 at 10:00 AM. |
![]() |
Tags |
excel 2013 formula, functions, sum |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Display multiple values as new values based on selection from template. | MvdB | Excel | 2 | 09-29-2015 08:51 PM |
Hide rows in multiple columns based on zero values | Deane | Excel Programming | 19 | 06-23-2015 11:24 PM |
![]() |
grexcelman | Excel Programming | 5 | 12-05-2014 11:36 AM |
swap values | s7y | Excel Programming | 0 | 05-15-2012 01:32 PM |
![]() |
Learner7 | Excel | 5 | 06-12-2010 09:54 AM |