I want to use "sumif" function in an excel worksheet, but I have 2 criteria I must fulfill. How would I got about doing that?
I am currently running windows XP and using the office 2003 for Excel. Any help would be appreciated. Thanks
buggytoast 0 Newbie Poster
MartyMcFly 9 Practically a Master Poster
The syntax is "SUMIF(range,criteria,sum_range)" (without ")
So an example might be;
SUMIF(A1:A3,">20",B1:B3)
So the value of B1 will be sumed if the value of A1 is over 20. The value of B2 will be sumed if the value of A2 is over 20. The value of B3 will be sumed if the value of A3 is over 20.
So if A1=17 and A2 =22 and A3=24. B1=43 and B2=27 and B3=13
The sumif value will be 40 :)
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.