SUMIF Function in Excel 5.0
Lawrence Wood
Sum-if formula. SUMIF was added to handle all the
easy cases (of which most are) but in the case of
multiple criteria you would have to use something like
{=SUM(IF((A2:A5="Buy")*(B2:B5="Grey"),C2:C5,0))}
Remember to press cntl-shift-enter to enter the formula.
This will give you the {} at the begining and end
of the formula, you dont type those yourself. Good
luck.
lw
************************************************************
#include<stddisclaimer.h>
The opinions stated above are entirely mine and do not
represent the opinions of my employer in any form
whatsoever. I just try help as I can.
************************************************************
In article <95026.193...@QUCDN.QueensU.CA> BJK wrote:
> I have been trying to use the SUMIF function to do some calculations. But I
> would like the summing to occur if there is a certain value in Column A and
> another certain value in column B. For example:
> A B C
> Buy Grey 80
> Buy Blue 80
> Buy Grey 90
> Sell Grey 100
> I would like the SUMIF to work if A="Buy" and B="Grey", giving me the answer
> 170. I have wriiten the function like:
> SUMIF(Sheet!A:B, AND(Sheet!A="Buy",Sheet!B="Grey",Sheet!C:C)
> But this gives me an answer of zero, which is not what I want. Does anybody
> have any suggestions on how to do this with SUMIF or is there some other way of
> accomplishing this? Thank you.
>
