Addition of two Column with Condition

's Computer Specifications

Hi
I need a formula that calculate two or more column with given
condition, I used SUMIF and DSUM , but it cant worked.

's Computer Specifications

On Feb 21, 4:12*am, Tayyab <sheikhtay...@gmail.com> wrote:
> I need a formula that calculate two or more column with given
> condition, I used SUMIF and DSUM , but it cant worked.

Difficult to answer without a specific example. Perhaps one of the
following will help:

=SUMIF(A1:A100,"<100",B1:B100)+SUMIF(A1:A100,"<100",C1:C100)

or

=SUMPRODUCT((A1:A100<100)*(B1:C100))

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need VBA for for column addition and on condition resets to 0	C	Microsoft Excel Programming	2	20th Apr 2009 08:09 PM
Based on a condition in one column, search for a year in another column, and display data from another column in the same row >> look	MPSingley@midamerican.com	Microsoft Excel Programming	2	30th Dec 2006 06:23 PM
Based on a condition in one column, search for a year in another column, and display data from another column in the same row >> look	MPSingley@midamerican.com	Microsoft Excel Misc	0	27th Dec 2006 04:31 PM
Re: Addition base on condition	JulieD	Microsoft Excel Worksheet Functions	2	15th Apr 2005 08:39 PM
Amend formula to include addition condition	Pat	Microsoft Excel Worksheet Functions	1	16th Mar 2005 03:36 PM