Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct /And
I hope this is answered elsewhere I couldn't find anything relevant.
I want to sum a column where 2 conditions are met. I have tried the following formula but can't seem to get it to work. =Sumproduct(--And(Sheet2!$A$1:$A$300=A2,Sheet2!$B$1:$B$300="Accr ual")*Sheet2!$C$1:$C$300) I am sure I have used a similar formula before but can't remember where. Thanks Rick |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct /And
Try
=SUMPRODUCT(--(Sheet2!$A$1:$A$300=A2),--(Sheet2!$B$1:$B$300="Accrual"),--(Sheet2!$C$1:$C$300)) If this post helps click Yes --------------- Jacob Skaria "Rick" wrote: I hope this is answered elsewhere I couldn't find anything relevant. I want to sum a column where 2 conditions are met. I have tried the following formula but can't seem to get it to work. =Sumproduct(--And(Sheet2!$A$1:$A$300=A2,Sheet2!$B$1:$B$300="Accr ual")*Sheet2!$C$1:$C$300) I am sure I have used a similar formula before but can't remember where. Thanks Rick |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct /And
=SUMPRODUCT(--(Sheet2!$A$1:$A$300=A2),--(Sheet2!$B$1:$B$300="Accrual"),--(Sheet2!$C$1:$C$300))
No need for the double unary -- on the last array: =SUMPRODUCT(--(Sheet2!$A$1:$A$300=A2),--(Sheet2!$B$1:$B$300="Accrual"),Sheet2!$C$1:$C$300) -- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... Try =SUMPRODUCT(--(Sheet2!$A$1:$A$300=A2),--(Sheet2!$B$1:$B$300="Accrual"),--(Sheet2!$C$1:$C$300)) If this post helps click Yes --------------- Jacob Skaria "Rick" wrote: I hope this is answered elsewhere I couldn't find anything relevant. I want to sum a column where 2 conditions are met. I have tried the following formula but can't seem to get it to work. =Sumproduct(--And(Sheet2!$A$1:$A$300=A2,Sheet2!$B$1:$B$300="Accr ual")*Sheet2!$C$1:$C$300) I am sure I have used a similar formula before but can't remember where. Thanks Rick |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct /And
Hi,
In 2007 you can also use: SUMIFS(Sheet2!C$1:C$300,Sheet2!A$1:A$300,A2,Sheet2 !B$1:B$300,"Accrual" -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Rick" wrote: I hope this is answered elsewhere I couldn't find anything relevant. I want to sum a column where 2 conditions are met. I have tried the following formula but can't seem to get it to work. =Sumproduct(--And(Sheet2!$A$1:$A$300=A2,Sheet2!$B$1:$B$300="Accr ual")*Sheet2!$C$1:$C$300) I am sure I have used a similar formula before but can't remember where. Thanks Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
#VALUE! from SUMPRODUCT | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
SUMPRODUCT Help please | Excel Discussion (Misc queries) | |||
SUMPRODUCT help again! | Excel Worksheet Functions |