View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DaveMoore DaveMoore is offline
external usenet poster
 
Posts: 32
Default Do I need SUMPRODUCT?

The following is a formula I am using that totals a range meeting a
single criteria.

=SUMIF(D2:D254,D507,E2:E254)

However, I now want to give an additional condition; that is
(F2:F254) = ""

I think I want SUMPRODUCT but I am not sure how to use it?
Can anyone help?
My thanks to those who can.

Dave Moore