In C1: =SUMIF(B1:B5,"wss",A1:A5)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---
"Graham" wrote:
I want to add specific values in colunm A that meet a criteria in colunm B
A B
10 wss
20 bll
30 wss
40 wss
50 rrr
I want to create a rule to add A that =wss in B

Thanx