Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula help
Hi! I really need help to arrange this formula!! I work with students in a school and need to count a certain value if a different cell has a certain value. Each student has their own column. One row for each column is entitled: "Active client". I will answer "y" if that student is currently working with me, and "n" if not. Then each row will either have a "x" or be blank. I want to calculate the total "x"s for all the students in each row, only if their "Active status" is "y". Total.......Name...........John.......Mary......Su e ...............Active.............Y............Y.. ......N ..2...........In School........X............X.........X ..0...........Red hair..................................X ..1...........Happy.............X................. ....X Please can anyone help me? Many, Many thanks! keith -- hopeace ------------------------------------------------------------------------ hopeace's Profile: http://www.excelforum.com/member.php...o&userid=28009 View this thread: http://www.excelforum.com/showthread...hreadid=475147 |
#2
|
|||
|
|||
Assuming that A1:E5 contains your data, try...
A3, copied down: =SUMPRODUCT(--($C$2:$E$2="Y"),--(C3:E3="X")) Hope this helps! In article , hopeace wrote: Hi! I really need help to arrange this formula!! I work with students in a school and need to count a certain value if a different cell has a certain value. Each student has their own column. One row for each column is entitled: "Active client". I will answer "y" if that student is currently working with me, and "n" if not. Then each row will either have a "x" or be blank. I want to calculate the total "x"s for all the students in each row, only if their "Active status" is "y". Total.......Name...........John.......Mary......Su e ..............Active.............Y............Y... .....N .2...........In School........X............X.........X .0...........Red hair..................................X .1...........Happy.............X.................. ...X Please can anyone help me? Many, Many thanks! keith |
#3
|
|||
|
|||
Thank you Domenic! I would never have been able to figure that out, and it worked! I wish for you a good day full of sunshine and fortune. These stats are ultimately help me do a better job at supporting the youth in the school I work at (im a youth and family counsellor). Thanks for your help. keith -- hopeace ------------------------------------------------------------------------ hopeace's Profile: http://www.excelforum.com/member.php...o&userid=28009 View this thread: http://www.excelforum.com/showthread...hreadid=475147 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |