Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sum values depending on prefefined criterias
Hi all
I am using excel to calculate some statistics: I have the following list 1) 2) a) e n b) e y c) e y d) e y e) f n f) f n g) g y I want excel to "calculate" the following values e 1 n e 3 y f 2 n f 0 y g 0 n g 0 y I hope anybody can help me. Best Regards |
#2
|
|||
|
|||
=sumproduct(--(A1:A100="e"),--(B1:B100="n"))
etc -- HTH RP (remove nothere from the email address if mailing direct) "jakees" wrote in message om... Hi all I am using excel to calculate some statistics: I have the following list 1) 2) a) e n b) e y c) e y d) e y e) f n f) f n g) g y I want excel to "calculate" the following values e 1 n e 3 y f 2 n f 0 y g 0 n g 0 y I hope anybody can help me. Best Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
Finding unique values with Criterias | Excel Discussion (Misc queries) | |||
How To Use Cells Without Values in a Formula | Excel Worksheet Functions | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Formula to list unique values | Excel Worksheet Functions |