Hi
I have a sumifs formula that calculate values based on value, date & supplier (named ranges as per below).
=SUMIFS(AMOUNT,SUPPLIER1,$A24,DATE,">="&C$23,DATE,"<="&EOMONTH(C$23,0))
This works for when the row providing the data is a one off value but in another column (named range - Occurence) has a value of 0 its one off but it says 1 it should be every month, if it says 12 it should be every 12 months. At them moment i have to input the item the number of times the value occurs for.
For example i have microsoft office and payment happens monthly so in "Occurance" column it says 12 and so i would like that value to appear for the next 12 months rather than having to enter 12 rows with the 12 months manually
thanks in advance, hope you can help
I have a sumifs formula that calculate values based on value, date & supplier (named ranges as per below).
=SUMIFS(AMOUNT,SUPPLIER1,$A24,DATE,">="&C$23,DATE,"<="&EOMONTH(C$23,0))
This works for when the row providing the data is a one off value but in another column (named range - Occurence) has a value of 0 its one off but it says 1 it should be every month, if it says 12 it should be every 12 months. At them moment i have to input the item the number of times the value occurs for.
For example i have microsoft office and payment happens monthly so in "Occurance" column it says 12 and so i would like that value to appear for the next 12 months rather than having to enter 12 rows with the 12 months manually
thanks in advance, hope you can help