Remember Me?

#1
 Doug Posts: n/a
sumif 2 criteria

This is probably very simple but I am having problem writing the sumif
formuala.

The range I want to add up is AJ99:Aj3467
if f36 = d99:d3467 and
if g36 = b99:3467
#2
 JulieD Posts: n/a

Hi Doug

what do you mean by
if F36=D99:D3467 (and the same for the other condition)

generally the solution to a multiple criteria SUMIF is a SUMPRODUCT, e.g.
=SUMPRODUCT((A1:A100="Jan")*(B1:B100="Fred")*(C1:C 100))
ie sum the values in column C where Jan occurs in column A & Fred occurs in
column B

but i don't understand your criteria so i can't generate the actual formula
for you but hopefully this will put you on the right track to a solution.

Regards
JulieD
PS do you mean
=SUMPRODUCT((d99:d3467=F36)*(b99:b3467=G36)*(AJ99: AJ3467 ))

"Doug" wrote in message
...
This is probably very simple but I am having problem writing the sumif
formuala.

The range I want to add up is AJ99:Aj3467
if f36 = d99:d3467 and
if g36 = b99:3467

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Graham Haughs Excel Discussion (Misc queries) 3 January 14th 05 09:19 AM Brent Martin Excel Discussion (Misc queries) 6 January 7th 05 06:17 AM Stan Excel Discussion (Misc queries) 5 December 16th 04 11:12 PM Frank Kabel Excel Discussion (Misc queries) 1 December 15th 04 10:56 PM ExcelLEarner New Users to Excel 1 December 5th 04 05:54 AM

All times are GMT +1. The time now is 12:36 AM.