View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
czamora czamora is offline
external usenet poster
 
Posts: 3
Default sum with two conditions and a wildcard

Someone could help me,

I want to use a function that calculate something like a
SUMIF with two conditions.

Somebody says that I could use the SUMPRODUCT worksheet
function, but I have a problem with this function because
I need to use the wildcard "*" to find more occurrences,
as the same way as I use it on the SUMIF function.

Example: I have a lot of accounts and I need to calculate
all the acounts which has the enable column on TRUE and
the account column starts with "acc01"

Account # Enable Balance
acc0101, USA TRUE 500
acc0102, UK TRUE 2000
acc0201, FR FALSE 223.5
acc0222, USA FALSE 12000
acc0103, FR FALSE 250.36

Expected output: 2500

Thanks in advance