Add If ?

G

GatorGirl

I am trying to have a cell total figures if a cell in a different column
range is met.
Ex.
Column A Sales Month
Column B Sales Figure

Entries are made in random order so i want the total of sales for the month
specified in a cell.

I looked at sumif but didn't seem to work because i need to include the
range of entries to get all of the specified month.

:)
 
T

T. Valko

Column A Sales Month

So, what is the Sales Month? A date like 1/1/2007? The month number like 1
(for January)? A TEXT string like Jan? A DATE like 1/1/2007 formatted to
display like Jan?

Biff
 
H

Helge

Hi,

I have never used the double negative signs in any formula. I have come
across it in several Q&A in var. userforums though, so however obvious
it may be (to the the rest of you), please excuse my ignorance.

I need an explanation, what is the purpose, and the logics behind, the
double negative signs?

By testing the formula below, I see the effect but I still don't get it :-(

T.i.a.

Helge
 
Top