SumIf Criteria Matches

[Debbie Dies]

I am trying to sum the amounts in column c if they match the criteria i
colum f.

I can sum c if column f is a single criteria. My problem is I wan
column c to sum if the criteria in column f is <>.

Example:
column c column f
1000 -- 13.5
2000 -- 8
3000 -- 15
4000 -- 20

I want to get the sum in column c if column f is >8 and <14.99. Thi
should total 1000. I can't seem to find the right formula. I hav
tried using =sumif(F2:f19,>8<14.99,C2:c19). I must have somethin
wrong. Please help

 

[Domenic]

Hi Debbie,

Try,

=SUMPRODUCT((F2:F19>8)*(F2:F19<14.99),C2:C19)

Hope this helps

 

[Peo Sjoblom]

One way

=SUMIF(F1:F100,">8",C1:C100)-SUMIF(F1:F100,">=14.99",C1:C100)

or

=SUMPRODUCT(--(F1:F100>8),--(F1:F100<14.99),C1:C100)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)