LinkBack URL
About LinkBacks
Here is a sample of a formula I am attempting:
If C6:C35=AB66 and F6:F35=AB67 then sum(R6:R35)
Can someone help me clean this up??
thanks
Here is a sample of a formula I am attempting:
If C6:C35=AB66 and F6:F35=AB67 then sum(R6:R35)
Can someone help me clean this up??
thanks
Last edited by simpson; 05-19-2010 at 02:45 PM.
How can a range be = a cell? What are you trying to do? Sum C6:C35 and compare the result to AB66? If so, then
=if(and(sum(C6:C35)=AB66,sum(F6:F35)=AB67),sum(R6:R35),"")
If that is not what you need, explain a bit more, and attach some sample data in a workbook.
Hi,
Do you mean if every cell in the range C6:C35 = AB66, and ditto with every cell in F6:F35 having to equal AB67?
And what result do you want if they don't?
Rgds
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Maybe
=if(and(countif(C6:C35,AB66)=30,countif(F6:F35,AB67)=30),sum(R6:R35),"")
My sumif formula reads
=SUMIF($C$6:$C$36,$AB66,R$6:R$35)
and it works great. but now I've added another criteria that needs to be met (F6:F35=AB67)before the sum of R6:R35
does that help?
You need Sumifs, then
=SUMIFS(R$6:R$35,$C$6:$C$36,$AB66,F$6:F$35,$AB67)
That works!
Thank you so much!
Sorry, is SUMIFS a standard excel formula? I can't find it here...
Skipan, please take a few minutes to read the forum rules, and then start your own thread.
Thanks.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks