View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
yvonneb yvonneb is offline
external usenet poster
 
Posts: 5
Default SUMIF using two ranges

I would like to use SUMIF with two IF ranges ie:

If Column A="xxx" and Column B="yyy" then sum column D

Is this possible? I have only every used SUMIF(A:A,"xxx",D:D)

Many thanks
Yvonne