Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What function(s) to use?
Sorry about the vague title but I've really got no idea how to describe this.
Instead I'll try to explain my problem by example. http://img284.imageshack.us/img284/9...elquery2jk.png If you take a look at the above picture, you'll see that there are two rows of data. What I want to do is have Excel work out how many 'A' items have 'Yes' next to them (and similarity, how many B's do) Can someone tell me what the formula for that would be? Thanks in Advance |
#2
|
|||
|
|||
Try
=SUMPRODUCT(--(A1:A10="A"),--(B1:B10="YES")) -- Regards Roger Govier "Barguast" wrote in message ... Sorry about the vague title but I've really got no idea how to describe this. Instead I'll try to explain my problem by example. http://img284.imageshack.us/img284/9...elquery2jk.png If you take a look at the above picture, you'll see that there are two rows of data. What I want to do is have Excel work out how many 'A' items have 'Yes' next to them (and similarity, how many B's do) Can someone tell me what the formula for that would be? Thanks in Advance |
#3
|
|||
|
|||
One way:
=SUMPRODUCT(--(A1:A10="A"),--(B1:B10="Yes")) In article , "Barguast" wrote: Sorry about the vague title but I've really got no idea how to describe this. Instead I'll try to explain my problem by example. http://img284.imageshack.us/img284/9...elquery2jk.png If you take a look at the above picture, you'll see that there are two rows of data. What I want to do is have Excel work out how many 'A' items have 'Yes' next to them (and similarity, how many B's do) Can someone tell me what the formula for that would be? Thanks in Advance |
#4
|
|||
|
|||
"Roger Govier" wrote in message ... Try =SUMPRODUCT(--(A1:A10="A"),--(B1:B10="YES")) :-) |
#5
|
|||
|
|||
I have no idea how that works... but it does! Thanks :)
"Roger Govier" wrote: Try =SUMPRODUCT(--(A1:A10="A"),--(B1:B10="YES")) -- Regards Roger Govier |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Confused about arrays and ranges in functions | Excel Worksheet Functions | |||
Default User Defined Functions - How? | Excel Discussion (Misc queries) | |||
PASTE DOWN FUNCTIONS | Excel Worksheet Functions | |||
3 questions about automated c++ com add-in worksheet functions | Excel Worksheet Functions | |||
# of Functions per cell | Excel Worksheet Functions |