Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing List Entries 2
Thanks Guys!!!
That works great! Is it possible to refine this count further by only returning a count if a condition in another column is also met? For example, say I have my drop down lists in column A and in column B there are only "1"s and "0"s or "YES" and "NO". Can I return a count for the initial 5 possibilites only if they are paired with a "1" or "YES"? In other words, if A1 contains "C" and B1 contains "1", count 1 for "C" but if A1 contains "C" and B1 contains "0" or is blank return a count of 0 for "C" Sorry I'm sure I could have worded this better, hope it makes sense. Cheers! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing List Entries 2
See one response in your earlier thread.
Pl stay within the same thread .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Zoltan" wrote: Thanks Guys!!! That works great! Is it possible to refine this count further by only returning a count if a condition in another column is also met? For example, say I have my drop down lists in column A and in column B there are only "1"s and "0"s or "YES" and "NO". Can I return a count for the initial 5 possibilites only if they are paired with a "1" or "YES"? In other words, if A1 contains "C" and B1 contains "1", count 1 for "C" but if A1 contains "C" and B1 contains "0" or is blank return a count of 0 for "C" Sorry I'm sure I could have worded this better, hope it makes sense. Cheers! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing List entries | Excel Discussion (Misc queries) | |||
Summing numbers in a list when they meet a critieria in another co | Excel Discussion (Misc queries) | |||
Summing the last 7 non-blank entries in a row of data | Excel Discussion (Misc queries) | |||
Help...Summing Items Scattered in a list | Excel Discussion (Misc queries) | |||
Removing all entries in one list that appear in a different list | Excel Discussion (Misc queries) |