Hello Oh Wise Ones (again!)

I think I need to use SumIf, but don't know exactly how.

In column A, I have a variety of letters and blank spaces. In column C I
have a variety of numbers and blank spaces.

I'd like a formula to calculate the sum of all numbers in column C if the
letter in column A is "F". (so if A3 and A8 and A9 are F, then the formula
would calculate C3+ C8 + C9). There would never be a time where the text in
column A would equal F and the corresponding cell in column C would be blank.

If you have any ideas, I'd be delighted.

Thank you.

"julie" skrev i en meddelelse
...
Hello Oh Wise Ones (again!)

I think I need to use SumIf, but don't know exactly how.

In column A, I have a variety of letters and blank spaces. In column C I
have a variety of numbers and blank spaces.

I'd like a formula to calculate the sum of all numbers in column C if the
letter in column A is "F". (so if A3 and A8 and A9 are F, then the
formula
would calculate C3+ C8 + C9). There would never be a time where the text
in
column A would equal F and the corresponding cell in column C would be
blank.

If you have any ideas, I'd be delighted.

Thank you.

Hello Julie

One way:

=COUNTIF(A1:A100,"f",C1:C100)


--
Best regards
Leo Heuser

Followup to newsgroup only please.

Try:

=SUMIF(A1:A20,"F",C1:C20)

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"julie" wrote in message
...
Hello Oh Wise Ones (again!)

I think I need to use SumIf, but don't know exactly how.

In column A, I have a variety of letters and blank spaces. In column C I
have a variety of numbers and blank spaces.

I'd like a formula to calculate the sum of all numbers in column C if the
letter in column A is "F". (so if A3 and A8 and A9 are F, then the
formula
would calculate C3+ C8 + C9). There would never be a time where the text
in
column A would equal F and the corresponding cell in column C would be
blank.

If you have any ideas, I'd be delighted.

Thank you.

Oh those pesky quotation marks. No wonder it wasn't working....

THank you thank you!!

"Sandy Mann" wrote:

Try:

=SUMIF(A1:A20,"F",C1:C20)

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"julie" wrote in message
...
Hello Oh Wise Ones (again!)

I think I need to use SumIf, but don't know exactly how.

In column A, I have a variety of letters and blank spaces. In column C I
have a variety of numbers and blank spaces.

I'd like a formula to calculate the sum of all numbers in column C if the
letter in column A is "F". (so if A3 and A8 and A9 are F, then the
formula
would calculate C3+ C8 + C9). There would never be a time where the text
in
column A would equal F and the corresponding cell in column C would be
blank.

If you have any ideas, I'd be delighted.

Thank you.

=SUMIF(A1:A10,"F",C1:C10)
or you could use sumproduct
=SUMPRODUCT((A1:A10="F")*(C1:C10))

Greetings from New Zealand
Bill K
"julie" wrote in message
...
Hello Oh Wise Ones (again!)

I think I need to use SumIf, but don't know exactly how.

In column A, I have a variety of letters and blank spaces. In column C I
have a variety of numbers and blank spaces.

I'd like a formula to calculate the sum of all numbers in column C if the
letter in column A is "F". (so if A3 and A8 and A9 are F, then the
formula
would calculate C3+ C8 + C9). There would never be a time where the text
in
column A would equal F and the corresponding cell in column C would be
blank.

If you have any ideas, I'd be delighted.

Thank you.