IF with SUMIF ? Or ??
I have this formula that works for a partial need.
=SUMIF($F:$F,110,$G:$G)
How can I modify the above formula to provide the above result only if the A
column has #'s =100 and < 199 ? The A column has #'s from 0 thru <400.
I need other ranges also, but if I get the above, I could figure out the
others.
Thanks much,
Steve
|