Excel help please

Saytan · 29 Jun 2009 at 15:25

hi there

i'm trying to fix a spreadsheet that's converted from lotsu 1-2-3 to excel

basically, i need to take any value in (for example) column C and sum them, but only if the corresponding cell in column A contains the number 1... if you follow?

it seems i can do this using DSUM, but i cannot get it to work

Saytan · 29 Jun 2009 at 15:30

hmmm - think i've cracked this using SUMIF to do this

=SUMIF(A3:A1500,"=1",C3:C1500)

any sensible reasons why this shouldnt work?

Malakite · 29 Jun 2009 at 15:41

nope, the sumif is exactly what your looking for.

Participant · 29 Jun 2009 at 16:36

Saytan said:
hmmm - think i've cracked this using SUMIF to do this

=SUMIF(A3:A1500,"=1",C3:C1500)

any sensible reasons why this shouldnt work?

Only if the cells in column A are formatted as text. SUMIF won't sum text cells, so you'd need to re-format them as general or number then probably do a find and replace 1 with 1, 2 with 2, etc.