Thread: sumifs return #value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] cindywang6135@gmail.com is offline
external usenet poster
  
Posts: 3
Default sumifs return #value
My sumifs function return #value. I tried in both ways:

=SUMIFS(D$5:D$40,A4:A40,A51,C$5:C$41,B51)

=SUMIFS(D$5:D$40,A5:A41,"="&A52,C$5:C$41,"="&B52)

It all returns #value. Could you please help? Thanks,

Reply With QuoteReply With Quote