View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default 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