Sumproduct, Validation & Blancs

[Bec]

I have the following categories

Monitor-CRT = asstype
17 inch = assdescr
1 = age

formuala reads
=sumproduct(--(asstype=selection1),--(assdescr=selection2),--(age=1),

I'm using a validation list to select the criteria needed
Monitor-CRT & 17 Inch - this works fine with correct calculation

but if I only want to search on asstype and the assdescr is blank it doesn't
return the correct total because in the data the assdescr doesn't have any
blank fields.
How can I have the formuala in the one cell?

Suggestions?

TIA
Bec

 

[Bob Phillips]

Is this what you mean

=IF(selection2="",sumproduct(--(asstype=selection1),--(age=1),sumproduct(--(asstype=selection1),--(assdescr=selection2),--(age=1))

 

[Bec]

What if selection2 isn't blank?

Is this what you mean

=IF(selection2="",sumproduct(--(asstype=selection1),--(age=1),sumproduct(--(asstype=selection1),--(assdescr=selection2),--(age=1))

--
__________________________________
HTH

Bob