Thread: SUMIFS error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NicoleC NicoleC is offline
external usenet poster
 
Posts: 4
Default SUMIFS error

Price Type AGENT
$84,000.00 L JONES

All I want to do is get a sum of the price column if type=L and agent =JONES

Here is what I have but I keep getting a Value error??

=SUMIFS(B46:B77,C46:C77,"L",G46:H77,"JONES")

I don't see what it is wrong.
I read one of the posts stating to put a value in each cell to correct the
bug but that did not work either.