Thank you Brad. I knew there was a way to use the (:) but I couldnt get it
working in there. I dont make many spreadsheets and have never had to make
one due this, but now that i see how it it is input in the "Arguments"
window, it makes more since to me.
Thanks again.



"Brad" wrote:

This will work

=SUMIF(E5:E91,"Part",b5:b91)

HTH

"www.SemperFratres.com" wrote:

I have a rather lengthy formula that I need to reduce in size and make it
read correctly.

I have some cells in column B that I need to add together if word in column
E is true. I have several different words that will be in column E and need
to create a formula for each one, and adding the rows in column B that = true
for column E. I hope you understand... if not, maybe you will understand
what I am trying to do with the formula below.

=IF(E5="PART",SUM(B5),"")+IF(E6="PART",SUM(B6),"") +IF(E7="PART",SUM(B7),"")+IF(E8="PART",SUM(B8),"
")+IF(E9="PART",SUM(B9),"")+IF(E10="PART",SUM(B10) ,"")+IF(E11="PART",SUM(B11),"")+IF(E12="PART",S U
M(B12),"")+IF(E13="PART",SUM(B13),"")+IF(E14="PART ",SUM(B14),"")+IF(E15="PART",SUM(B15),"")+IF(E 16
="PART",SUM(B16),"")+IF(E17="PART",SUM(B17),"")+IF (E18="PART",SUM(B18),"")+IF(E19="PART",SUM(B19),
"")+IF(E20="PART",SUM(B20),"")+IF(E21="PART",SUM(B 21),"")+IF(E22="PART",SUM(B22),"")+IF(E23="PART"
,SUM(B23),"")+IF(E24="PART",SUM(B24),"")+IF(E25="P ART",SUM(B25),"")+IF(E26="PART",SUM(B26),"")+IF(
E27="PART",SUM(B27),"")+IF(E28="PART",SUM(B28),"") +IF(E29="PART",SUM(B29),"")+IF(E30="PART",SUM(B3
0),"")+IF(E31="PART",SUM(B31),"")+IF(E32="PART",SU M(B32),"")+IF(E33="PART",SUM(B33),"")+IF(E34="PA
RT",SUM(B34),"")+IF(E35="PART",SUM(B35),"")+IF(E36 ="PART",SUM(B36),"")+IF(E37="PART",SUM(B37),"") +
IF(E38="PART",SUM(B38),"")+IF(E39="PART",SUM(B39), "")+IF(E40="PART",SUM(B40),"")+IF(E41="PART",S UM
(B41),"")+IF(E=54"PART",SUM(B54),"")+IF(E55="PART" ,SUM(B55),"")+IF(E56="PART",SUM(B56),"")+IF(E57=
"PART",SUM(B57),"")+IF(E58="PART",SUM(B58),"")+IF( E59="PART",SUM(B59),"")+IF(E60="PART",SUM(B60),"
")+IF(E61="PART",SUM(B61),"")+IF(E62="PART",SUM(B6 2),"")+IF(E63="PART",SUM(B63),"")+IF(E64="PART",
SUM(B64),"")+IF(E65="PART",SUM(B65),"")+IF(E66="PA RT",SUM(B66),"")+IF(E67="PART",SUM(B67),"")+IF(E
68="PART",SUM(B68),"")+IF(E69="PART",SUM(B69),"")+ IF(E70="PART",SUM(B70),"")+IF(E71="PART",SUM(B71
),"")+IF(E72="PART",SUM(B72),"")+IF(E73="PART",SUM (B73),"")+IF(E74="PART",SUM(B74),"")+IF(E75="PAR
T",SUM(B75),"")+IF(E76="PART",SUM(B76),"")+IF(E77= "PART",SUM(B77),"")+IF(E78="PART",SUM(B78),"") +I
F(E79="PART",SUM(B79),"")+IF(E80="PART",SUM(B80)," ")+IF(E81="PART",SUM(B81),"")+IF(E82="PART",SU M(
B82),"")+IF(E83="PART",SUM(B83),"")+IF(E84="PART", SUM(B84),"")+IF(E85="PART",SUM(B85),"")+IF(E86="
PART",SUM(B86),"")+IF(E87="PART",SUM(B87),"")+IF(E 88="PART",SUM(B88),"")+IF(E89="PART",SUM(B89),""
)+IF(E90="PART",SUM(B90),"")+IF(E91="PART",SUM(B91 ),"")