Thread: SUMIF formula while filtering
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default SUMIF formula while filtering
wrote in message
...
On May 8, 3:13 pm, "T. Valko" wrote:
Try this:

=SUMPRODUCT(SUBTOTAL(3,OFFSET(H14:H267,ROW(H14:H26 7)-ROW(H14),0,1)),--(K14:*K267=E2),V14:V267)

--
Biff
Microsoft Excel MVP

wrote in message

...



I have the formula =SUMIF(K14:K267,E2,V14:V267) but want the number to
only reflect when I filter by data in column H. Any ideas?- Hide quoted
text -

- Show quoted text -


I get "0" when I do that... does it help to know that the data in
column "H" is text?


Hmmm...

It works for me.

Here's a small sample file that demonstrates this:

xSumifFilter.xls 17kb

http://cjoint.com/?fjaXQiGAoG

--
Biff
Microsoft Excel MVP


Reply With QuoteReply With Quote