#1   Report Post  
Old October 27th 04, 04:59 PM
Doug
 
Posts: n/a
Default 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   Report Post  
Old October 27th 04, 05:06 PM
JulieD
 
Posts: n/a
Default

Hi Doug

what do you mean by
if F36=D993467 (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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wildcard Selection Criteria Graham Haughs Excel Discussion (Misc queries) 3 January 14th 05 08:19 AM
SUMIF Criteria Brent Martin Excel Discussion (Misc queries) 6 January 7th 05 05:17 AM
SUMIF with only one criteria cell within range Stan Excel Discussion (Misc queries) 5 December 16th 04 10:12 PM
Sum or Sumif Frank Kabel Excel Discussion (Misc queries) 1 December 15th 04 09:56 PM
> and < criteria in one single expression in excel ExcelLEarner New Users to Excel 1 December 5th 04 04:54 AM


All times are GMT +1. The time now is 10:02 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017