Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct question
I have column A as year, column B as "yes" or "no", column C as a $
amount. How do I do a sumproduct of year=2007, col B=yes, the total the $ in col C? $ total for both Yes and 2007? Am I making sense? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct question
In .com, wx4usa
spake thusly: I have column A as year, column B as "yes" or "no", column C as a $ amount. How do I do a sumproduct of year=2007, col B=yes, the total the $ in col C? =SUMPRODUCT(($A$2:$A$20=2007)*($B$2:$B$20="yes")*$ C$2:$C$20) is one way. Change the ranges to suit. -- dman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct question | Excel Worksheet Functions | |||
SumProduct Question | Excel Worksheet Functions | |||
Question about sumproduct | Excel Discussion (Misc queries) | |||
Question about sumproduct | Excel Discussion (Misc queries) | |||
sumproduct question | Excel Worksheet Functions |