|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 13th, 2009, 03:22 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Urgent Help - CountIf
Hello,
In Sheet 1 Column B, I urgently need a formula to would execute the following: Take Column A value = "Red" in sheet 1. I need to look for value = "Red" in Sheet 2 column B and take the value in Column C only if and only if Column A value= 2010 Sheet 2 2010 Red $10 2015 Red $15 2017 Red $16 
|
|
#2
April 13th, 2009, 03:31 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Urgent Help - CountIf
Jeff,
This goes on Sheet1 and looks for "Red" in A1 =INDEX(Sheet2!C1:C20,MATCH(1,(Sheet2!B1:B20=A1)*(S heet2!A1:A20=2010),0)) This is an array formula which must be entered with CTRL+Shift+Enter and NOT 'just enter. If you do it correctly then Excel will put curly brackets around 'the formula{}. You can't type these yourself. If you Edit the ranges 'then you must re-enter as An array Mike "Jeff" wrote: Hello, In Sheet 1 Column B, I urgently need a formula to would execute the following: Take Column A value = "Red" in sheet 1. I need to look for value = "Red" in Sheet 2 column B and take the value in Column C only if and only if Column A value= 2010 Sheet 2 2010 Red $10 2015 Red $15 2017 Red $16
|
|
#3
April 13th, 2009, 03:36 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Urgent Help - CountIf
I may have misunderstood, do you want this
=SUMPRODUCT((Sheet2!B1:B20=A1)*(Sheet2!A1:A20=2010 )*(Sheet2!C1:C20)) Mike "Mike H" wrote: Jeff, This goes on Sheet1 and looks for "Red" in A1 =INDEX(Sheet2!C1:C20,MATCH(1,(Sheet2!B1:B20=A1)*(S heet2!A1:A20=2010),0)) This is an array formula which must be entered with CTRL+Shift+Enter and NOT 'just enter. If you do it correctly then Excel will put curly brackets around 'the formula{}. You can't type these yourself. If you Edit the ranges 'then you must re-enter as An array Mike "Jeff" wrote: Hello, In Sheet 1 Column B, I urgently need a formula to would execute the following: Take Column A value = "Red" in sheet 1. I need to look for value = "Red" in Sheet 2 column B and take the value in Column C only if and only if Column A value= 2010 Sheet 2 2010 Red $10 2015 Red $15 2017 Red $16
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
