Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MULTIPLE IF STATEMENTS PULLING DATA FROM MORE THAN ONE COLUMN
For the spreadsheet below, column A is the initials of a salesperson and
column B is the type of deal (f is a finance, c is a cash and L is a lease deal. I want to count the number of L's there are for GR and CC. I have tried many combinations of IF statements and cant figure out how to combine the two. How many times does L appear in column B when CC is in column A? Once I get it for one, I can make the necessary changes to count the rest. My spreadsheet looks like this column A B GR L GR L CC C CC L CC L CC L GR F GR C CC C GR L CC L CC C CC L GR F CC L |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
MULTIPLE IF STATEMENTS PULLING DATA FROM MORE THAN ONE COLUMN
How many times does L appear in column B
when CC is in column A? Try this: =SUMPRODUCT(--(A1:A10="CC"),--(B1:B10="L")) Better to use cells to hold the criteria: D1 = CC E1 = L =SUMPRODUCT(--(A1:A10=D1),--(B1:B10=E1)) -- Biff Microsoft Excel MVP "Jeremy A." <Jeremy wrote in message ... For the spreadsheet below, column A is the initials of a salesperson and column B is the type of deal (f is a finance, c is a cash and L is a lease deal. I want to count the number of L's there are for GR and CC. I have tried many combinations of IF statements and cant figure out how to combine the two. How many times does L appear in column B when CC is in column A? Once I get it for one, I can make the necessary changes to count the rest. My spreadsheet looks like this column A B GR L GR L CC C CC L CC L CC L GR F GR C CC C GR L CC L CC C CC L GR F CC L |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
MULTIPLE IF STATEMENTS PULLING DATA FROM MORE THAN ONE COLUMN
Thank you so much! It worked great!!
"T. Valko" wrote: How many times does L appear in column B when CC is in column A? Try this: =SUMPRODUCT(--(A1:A10="CC"),--(B1:B10="L")) Better to use cells to hold the criteria: D1 = CC E1 = L =SUMPRODUCT(--(A1:A10=D1),--(B1:B10=E1)) -- Biff Microsoft Excel MVP "Jeremy A." <Jeremy wrote in message ... For the spreadsheet below, column A is the initials of a salesperson and column B is the type of deal (f is a finance, c is a cash and L is a lease deal. I want to count the number of L's there are for GR and CC. I have tried many combinations of IF statements and cant figure out how to combine the two. How many times does L appear in column B when CC is in column A? Once I get it for one, I can make the necessary changes to count the rest. My spreadsheet looks like this column A B GR L GR L CC C CC L CC L CC L GR F GR C CC C GR L CC L CC C CC L GR F CC L |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
MULTIPLE IF STATEMENTS PULLING DATA FROM MORE THAN ONE COLUMN
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Jeremy A." wrote in message ... Thank you so much! It worked great!! "T. Valko" wrote: How many times does L appear in column B when CC is in column A? Try this: =SUMPRODUCT(--(A1:A10="CC"),--(B1:B10="L")) Better to use cells to hold the criteria: D1 = CC E1 = L =SUMPRODUCT(--(A1:A10=D1),--(B1:B10=E1)) -- Biff Microsoft Excel MVP "Jeremy A." <Jeremy wrote in message ... For the spreadsheet below, column A is the initials of a salesperson and column B is the type of deal (f is a finance, c is a cash and L is a lease deal. I want to count the number of L's there are for GR and CC. I have tried many combinations of IF statements and cant figure out how to combine the two. How many times does L appear in column B when CC is in column A? Once I get it for one, I can make the necessary changes to count the rest. My spreadsheet looks like this column A B GR L GR L CC C CC L CC L CC L GR F GR C CC C GR L CC L CC C CC L GR F CC L |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pulling data from multiple workbooks | Excel Discussion (Misc queries) | |||
Pulling data from multiple files | Excel Discussion (Misc queries) | |||
Help Pulling data from one column to another | Excel Discussion (Misc queries) | |||
Pulling data from multiple spreadsheet | Excel Worksheet Functions | |||
Pulling data from multiple rows and columns | Excel Worksheet Functions |