Hi,

I think I understand so try this in march.xls

=SUM(IF(([QTD.xls]Sheet1!$A$1:$A$100/B1=0.2), 1, 0))
Enter with Ctrl+Shift+Enter

It will divide each cell in QTD.xls by march.xls b1 and count to number of
time the result is = 20%. Change 0.2 to 0.3 for 30%

Mike

"RoadKill" wrote:

Okay, I am a total rookie with SumIFs. I want workbook March.xls to link
whatever is in cell B1 of March.xls to link to QTD.xls workbook column
A1:A100 and count the number of instances that are over 20% as well as those
over 30%.

Does this make sense?

Thanks