Sum based on date cell not being empty

**impy** · 08-28-2009, 02:27 PM

Hi there,

Looking for a bit of help with a formula, it's been years since I've used excel properly.

Here's what I'm trying to do:

I have a list of items and their prices, some of these items have been bought already and have the date of purchase stored in a date formatted cell.

I have a running total of these various items but I only want to sum the ones which have been purchased already ie only those with a purchase date.

I have the logic of how it should be done in my head, I just can't translate that in to a working formula.

Any help would be appreciated.

Cheers.

**Palmetto** · 08-28-2009, 02:34 PM

Which is it SUM or COUNT? Your thread title mentions SUM, but you also said:

I only want to count

Assuming:
column-A = dates
columb-B = values to sum

Formula in C

=SUMIF(A2:A6,"<>""",B2:B6)

**impy** · 08-28-2009, 02:38 PM

I want the sum total of the prices, so SUM edited the post to avoid any further confusion.

Tried your formula there but still adds all the items to the total

**Palmetto** · 08-28-2009, 02:41 PM

Seems to work for me.

**impy** · 08-28-2009, 02:50 PM

Ah I see what you've done now.

That's not what I meant, I don't think I explained myself properly.

This should show what I mean better

**Palmetto** · 08-28-2009, 02:59 PM

You only have to adapt the formula I gave you.

Anyway, in cell H8: =SUMIF(B2:B6,"<>""",F2:F6)

**impy** · 08-28-2009, 03:04 PM

Ah sorry mate, the "<>""" extra ""s were throwing it off.

Cheers for the help!

**Palmetto** · 08-28-2009, 03:34 PM

If you're satisfied with the solution, please mark the thread as solved and be sure to add to the reputation of all who helped by clicking on the Scales icon in a thread to which a helper responded.