Please help
I know of the formulae =sumif(a1:a21,"1 Bed",b1:b21). I would like to be able to use a data validation list for the "1 bed" section (so for instance there will be a list of 0 bed upto 5 bed) and then for the formulated cell to work out the rest when i select which number of bed property i want.
Does this make sense or shall i retype ?
If we assume the validation list is say in cell C1 and the SUMIF to be in C2
C2: =SUMIF($A$1:$A$21,$C$1,$B$1:$B$21)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Re: Data Validation List and Sumif
God your good, works perfectly!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks