Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif Formula /Sort Bug??? | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF COMBINATION?? | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions |