Forumula help using Countif
I have t-shirt sizes in col. B of a Pivot Table. A shirt is given to someone
who had deposited over $99. The deposit is in col. E of the same Pivot Table. How do I write the formula to find the total 'small', 'med', etc for those who deposited over $99. I keep getting an error message. |
Forumula help using Countif
=SUMPRODUCT(--(A2:A200="small"),--(B2:B20099))
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "NeedHelpFast" wrote in message ... I have t-shirt sizes in col. B of a Pivot Table. A shirt is given to someone who had deposited over $99. The deposit is in col. E of the same Pivot Table. How do I write the formula to find the total 'small', 'med', etc for those who deposited over $99. I keep getting an error message. |
All times are GMT +1. The time now is 03:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com