SUMIF

[Steved]

Hello from Steved

=SUMIF(F2:F1000,"1-City") returns 0, should be 70606

Ok my objective is to look for 1-City then sum F2:F1000
1-City is G2:G1000

I data sort the G:G then =SUM(H2:H116)gives me 70606

I know longer want to "Data Sort" to get a result.

Whats wrong with my SUMIF formula please.

Thankyou.

 

[Frank Kabel]

Hi
use
=SUMIF(G2:G1000,"1-City",F2:F1000)

where column G stores the city name and column F the values. Or if
column H stores the values (your description is not that clear) try:
=SUMIF(G2:G1000,"1-City",H2:H1000)

 

[Steved]

Thankyou it is what I require.

-----Original Message-----
Hi
use
=SUMIF(G2:G1000,"1-City",F2:F1000)

where column G stores the city name and column F the values. Or if
column H stores the values (your description is not that clear) try:
=SUMIF(G2:G1000,"1-City",H2:H1000)


--
Regards
Frank Kabel
Frankfurt, Germany



.