IF statement problems

A

Allison

Hello!

I am trying to get an IF statement to work and it just
doesn't want to cooperate. I think it should be an IF
statement, but I'm not strong with Excel and the Excel
Formulas book is confusing me further.

The current statement is =SUMIF(C:C,"FCI",D:D) and this
has worked fine for totaling all listings with FCI as
their choice (there are six choices in the drop down box,
but only FCI was needed for a separate total). However,
now it needs to be expanded to total all listings that
choose FCI, NTI and FCIC.

I have tried =SUMIF(C:C,"FCI","NTI","FCIC",D:D), =SUMIF
(C:C,"FCI"+"NTI"+"FCIC",D:D), etc. and have had no luck.
I'm hoping someone here can point me in the right
direction. If it would be easier to send the worksheet for
review, just let me know and I can forward it.

Many thanks!
Allison
 
B

Bernie Deitrick

Allison,

One general approach is to use multiple SUMIFs:

=SUMIF(C:C,"FCI",D:D)+SUMIF(C:C,"NTI",D:D)

HTH,
Bernie
MS Excel MVP
 
J

Jason Morin

You can just add 2 more SUMIF statements:

=SUMIF(C:C,"FCI",D:D)+SUMIF(C:C,"NTI",D:D)+SUMIF
(C:C,"FCIC",D:D)

or use SUMPRODUCT:

=SUMPRODUCT((C1:C1000={"FCI","NTI","FCIC"})*D1:D1000)

Note that you cannot reference entire columns when using
SUMPRODUCT.

HTH
Jason
Atlanta, GA
 
D

Domenic

=SUMPRODUCT(--(ISNUMBER(MATCH(C1:C100,{"FCI","NTI","FCIC"},0))),D1:D100)

Adjust the range accordingly. Note that SUMPRODUCT does not accept
whole column references, such as "C:C" or "D:D".

Hope this helps!.
 
Top