software

Col D Col G Col H
-160 VALUE IPG
20 VOLUME TSG

Example:
I'm trying to count values in column D that are greater than 10 and less
than 20 IF column G = VALUE AND column H = IPG. I have been struggling with
this since yesterday and just can't get it right. Does anyone know how to
write the formula so it will work?

Thanks!

DSUM could potentially do it for you - or an array formula would do it

=SUM(IF(D1923gt;0,IF(D1923lt;20,IF(G19:G23=quot;valuequot; ,IF(H19:H23=quot;IPGquot;,1,0)))))entered with ctrl shift enter

(change my 19 and 23 to the actual start and finish of the data rangeThanks Aidan!

I'm trying this example and playing with it. I'm wondering what the 1,0 at
the end represents and if I need to modify it at all. Would the DSUM work if
I'm not trying to SUM but COUNT the number of values that are greater than 10
amp; less than 20? I have several ranges I need to summarize based on the
corresponding column information in columns G amp; H that look like this:

For VALUE IPG:
COUNT numbers matching the below ranges.

No Data
Early gt;10 days
Early 5-10 days
Early 3-4 days
Early 1-2 days
On-Time
Late 1-2 days
Late 3-4 days
Late 5-10 days
Late gt; 10 days

Then do the same thing for VALUE TSG, etc. Did I present this originally in
a way that represents the goal?

THANKS AGAIN!

quot; wrote:

gt; DSUM could potentially do it for you - or an array formula would do it
gt;
gt; =SUM(IF(D1923gt;0,IF(D1923lt;20,IF(G19:G23=quot;valuequot; ,IF(H19:H23=quot;IPGquot;,1,0)))))
gt;
gt;
gt; entered with ctrl shift enter
gt;
gt; (change my 19 and 23 to the actual start and finish of the data range
gt;
gt;

(home now, so have my wifes email details!)

The 1,0 work with the array formula and return a 1 if true and a zero if
false - thus SUM gives the right result because it add's all the ones up -
it's a difficult thing to get to grips with in an array formula. I like the
concept of the D functions, BUT I've never yet got any of them to work!!!
quot;crafty_girlquot; gt; wrote in message
...
gt; Thanks Aidan!
gt;
gt; I'm trying this example and playing with it. I'm wondering what the 1,0 at
gt; the end represents and if I need to modify it at all. Would the DSUM work
if
gt; I'm not trying to SUM but COUNT the number of values that are greater than
10
gt; amp; less than 20? I have several ranges I need to summarize based on the
gt; corresponding column information in columns G amp; H that look like this:
gt;
gt; For VALUE IPG:
gt; COUNT numbers matching the below ranges.
gt;
gt; No Data
gt; Early gt;10 days
gt; Early 5-10 days
gt; Early 3-4 days
gt; Early 1-2 days
gt; On-Time
gt; Late 1-2 days
gt; Late 3-4 days
gt; Late 5-10 days
gt; Late gt; 10 days
gt;
gt; Then do the same thing for VALUE TSG, etc. Did I present this originally
in
gt; a way that represents the goal?
gt;
gt; THANKS AGAIN!
gt;
gt; quot; wrote:
gt;
gt; gt; DSUM could potentially do it for you - or an array formula would do it
gt; gt;
gt; gt;
=SUM(IF(D1923gt;0,IF(D1923lt;20,IF(G19:G23=quot;valuequot; ,IF(H19:H23=quot;IPGquot;,1,0)))))
gt; gt;
gt; gt;
gt; gt; entered with ctrl shift enter
gt; gt;
gt; gt; (change my 19 and 23 to the actual start and finish of the data range
gt; gt;
gt; gt;