SUMIF

  • Thread starter Thread starter Steved
  • Start date Start date
S

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.
 
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)
 
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



.
Click to expand...
 
Back
Top