help!

[Glenys]

Can anyone help me with this formula???
=SUMIF(S6:S32="A*",(F6:F34="F"))

Thanks

 

[RagDyeR]

Sumif will *add* numbers.

Since you can't add the alphabet, are you perhaps looking to *count*
something?

You will have to clarify exactly what you're looking to accomplish.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

Can anyone help me with this formula???
=SUMIF(S6:S32="A*",(F6:F34="F"))

Thanks

 

[Norman Harker]

Hi Glenys!

One way:

=SUMPRODUCT(--(LEFT(S6:S32,1)="A"),--(F6:F32="F"))

Note also the error in your formula where S range and F range are not
of equal length.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Tom Ogilvy]

=sumproduct(--(Left(S6:S32,1)="A"),--(F6:F34="F"))

will count the rows that begin with A in s column of the range and have F in
the f column of the range

 

[Tom Ogilvy]

=sumproduct(--(Left(S6:S32,1)="A"),--(F6:F34="F"))
didn't notice the diconnect in cell number of cells

=sumproduct(--(Left(S6:S32,1)="A"),--(F6:F32="F"))

 

[Norman Harker]

Hi Glenys!

It occurs to me that you are using A* as a the text to be looked for
as opposed to using the * as a wild card. You might use A* as a grade
in marking indicating above maximum expected level of performance.

If that's the case:

=SUMPRODUCT(--(LEFT(S6:S32,1)="A*"),--(F6:F32="F"))

In any event, the ranges must be the same length. If * was used as a
wild card, then note that SUMPRODUCT doesn't support them.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Norman Harker]

Doh!

I meant to say, if A* is the string being sought use:

=SUMPRODUCT(--(S6:S32="A*"),--(F6:F32="F"))

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Glenys]

Thank you very much for your help it was very much appreciated. The
formula worked in the end without shooting error messages at me.


Glenys