Chris Davison
MrExcel MVP
- Joined
- Feb 15, 2002
- Messages
- 1,790
Morning all,
{"Name","Code","Amount";"John",1,5;"Paul",1,10;"George",1,15;"Ringo",1,20;"Bob",2,25;"John",2,30;"John",1,35;"John",1,40;"John",3,45}
I'm filtering column A so it only shows "John". We're all familiar with the =SUBTOTAL function that will sum only visible rows, but I'd like to subtotal only if the code is 1.
My ultimate goal is to have totals for each code which change as I filter by each name in column A.
(If it's not possible, I'll revert back to a pivot table)
so basically, can I use =SUBTOTAL with a single criteria ? (like =SUMIF does)
many thanks
Chris
edit - answer in the above example should be 80
This message was edited by Chris Davison on 2002-03-13 05:34
{"Name","Code","Amount";"John",1,5;"Paul",1,10;"George",1,15;"Ringo",1,20;"Bob",2,25;"John",2,30;"John",1,35;"John",1,40;"John",3,45}
I'm filtering column A so it only shows "John". We're all familiar with the =SUBTOTAL function that will sum only visible rows, but I'd like to subtotal only if the code is 1.
My ultimate goal is to have totals for each code which change as I filter by each name in column A.
(If it's not possible, I'll revert back to a pivot table)
so basically, can I use =SUBTOTAL with a single criteria ? (like =SUMIF does)
many thanks
Chris
edit - answer in the above example should be 80
This message was edited by Chris Davison on 2002-03-13 05:34