Thread: Need help with Excel Formula for calculating sum of products depending on criteria
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Need help with Excel Formula for calculating sum of products depending on criteria
Hi Archi,

Am Mon, 12 Mar 2012 09:55:31 +0000 schrieb Archi G:

I am using below formula but do not know how to check if cell value is
blank :
=SUMIF(D4:D16,"SP",C4:D16)

D21: =SUMIF(D4:D16,"DI",C4:C16)
D20: =SUMIF(D4:D16,"TP",C4:C16)
D19: =SUM(C4:C16)-D20-D21


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote