Formula similar to if/and/or based on 2 variables

[iahmed777]

Hi all

Im getting in a muddle with if/and/or and i cant seem to crack it

Problem

2 variables in 2 different cells

Cell 1

Can be any number from 1 - 12

Cell 2 can be any number from 1-12

i want it so that it only displays the range from the cell input combinations

eg if i put 3-3 (March to March) it will only show march data, if i put 2-7 (feb to july) it will only show that range data, the other non selecetd months will show blank

it works if i do 1 to something but then other combos do not work


Thanks in advanmce

[etaf]

how about
=SUMPRODUCT(($K$2:$V$2>=$F$3)*($K$2:$V$2<=$H$3)*($K$4:$V$19))
which i have added to F7

not sure what you want in the row 24

is it so that adds up each column which matches the range selected

i'll also do that - but your example shows feb and march totals , when 3 to 3 is selected

if you just want the column totals for cells matching the selected inputs then

=IF(AND(K$2>=$F$3,K$2<=$H$3),SUM(K4:K19),"")

[iahmed777]

Hi

Row 24 is where i would like the formula to be written so that it only shows a value if it is within the range of the selected cells

Otherwise i want it to be blank

So if i select 4-5 i only wnat columns 4-5 populated the rest should be blank

I have used the sum function but it could be any function, the key here is that the if statement is triggred if not in the selcted range

sorry of this does nto make sense

yes my example shows me not succeeding as when i put 4-4 in all should be blank

[etaf]

edited and updated my reply as you posted

see spreadsheet modified using

=IF(AND(K$2>=$F$3,K$2<=$H$3),SUM(K4:K19),"")

[iahmed777]

you are a bloody genius

i dont know why i didint see that..sorry for being a complete nooooob

[etaf]

you are welcome, dont apologise , thats why we are here , to help out

[iahmed777]

seriously this is sooooo good it works so sweetly!!!! i can use it with any function now like an index ...thanks again

[etaf]

you are welcome