Thread: SUMIF FUNCTION
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mo Mo is offline
external usenet poster
 
Posts: 69
Default SUMIF FUNCTION

I'm trying to accomplish adding figures that meet TWO criteria. When I use
the SUMIF FUNCTION, it only allows me to search for one criteria. Below is
what I'm looking to find. I keep getting an error.


=SUMIF('06-07 IT Exp. Pd. in
07-08'!E4:E100,"53000.5300200010.00300.206004.20060.5 4900.FMS",53000.5300200010.00300.206004.20060.5490 1.FMS",'06-07 IT Exp. Pd. in 07-08'!B4:B100).
--
Thank you for your help
MO
Albany, NY