G
goss
Hi ng.
Using xl xp pro.
Tried running conditional sum wizard on tab: Accnt_Dat
Through the wizard I established 3 criteria for the sum
Wizard prompts for resultant placement. I chose tab: Comm
Nothing appeared in the cell I selected.
I repeated all steps carefully in case I made an error.
Still nothing was placed in: Comm!$C$2.
I started trying to type by hand and came up with:
=(SUM(OR(IF(Accnt_Dat!$B$2:$B$1700="SALES-1", _
IF(Accnt_Dat!$B$2:$B$1700="SALES-2")))), _
IF(Accnt_Dat!$A$2:$A$1700=A2,Accnt_Dat!$C$2:$C$1700,0),0)
What I need is if Sales-1 or Sales-2 and match on val in col A
Sorry, so long. I entered continuation char's here, of course the
actual formula does not have the con' char's. Formula entered with ctrl+shift+enter.
Comparison on col A for match on unit number. So when drag formula down
compares for next unit number, same text search for "Sales-1", "Sales-2"
In every instance result returns as 0.
tia,
goss
Using xl xp pro.
Tried running conditional sum wizard on tab: Accnt_Dat
Through the wizard I established 3 criteria for the sum
Wizard prompts for resultant placement. I chose tab: Comm
Nothing appeared in the cell I selected.
I repeated all steps carefully in case I made an error.
Still nothing was placed in: Comm!$C$2.
I started trying to type by hand and came up with:
=(SUM(OR(IF(Accnt_Dat!$B$2:$B$1700="SALES-1", _
IF(Accnt_Dat!$B$2:$B$1700="SALES-2")))), _
IF(Accnt_Dat!$A$2:$A$1700=A2,Accnt_Dat!$C$2:$C$1700,0),0)
What I need is if Sales-1 or Sales-2 and match on val in col A
Sorry, so long. I entered continuation char's here, of course the
actual formula does not have the con' char's. Formula entered with ctrl+shift+enter.
Comparison on col A for match on unit number. So when drag formula down
compares for next unit number, same text search for "Sales-1", "Sales-2"
In every instance result returns as 0.
tia,
goss