# Search:

Type: Posts; User: willow1985; Keyword(s):

Page 1 of 6 1

1. ## Thread: Looking for a more elegant way to write the following countifs formula

by willow1985
Replies
5
Views
78

### Re: Looking for a more elegant way to write the following countifs formula

That works. Thank you very much :)
2. ## Thread: Looking for a more elegant way to write the following countifs formula

by willow1985
Replies
5
Views
78

### Re: Looking for a more elegant way to write the following countifs formula

=COUNTIFS('WO Report'!\$E:\$E,Z2,'WO Report'!\$S:\$S,\$B\$12,'WO Report'!\$S:\$S,\$C\$12,'WO Report'!\$S:\$S,\$D\$12)

This formula does not work but is there a reason why?

the reason I ask is that this...
3. ## Thread: Looking for a more elegant way to write the following countifs formula

by willow1985
Replies
5
Views
78

### Looking for a more elegant way to write the following countifs formula

Hello,

was wondering if anyone could help me with the below formula. Is there a more elegant way of writing it rather than adding each additional section?

I want the formula to count E:E if it...
4. ## Thread: VBA move print area down 1 row from active cell

by willow1985
Replies
7
Views
126

### Re: VBA move print area down 1 row from active cell

Played around a bit and so far this is working:

.PageSetup.PrintArea = _ .Range("Print_Area").Offset(2).Resize(.Range("Print_Area").Rows.Count - 1, _
...
5. ## Thread: VBA move print area down 1 row from active cell

by willow1985
Replies
7
Views
126

### Re: VBA move print area down 1 row from active cell

Actually this does not work. It is still moving down one row more than I need. Not sure how to adjust it that it moves to the selected cell...
6. ## Thread: VBA move print area down 1 row from active cell

by willow1985
Replies
7
Views
126

### Re: VBA move print area down 1 row from active cell

Nevermind, figured it out:

With ActiveSheet .PageSetup.PrintArea = _
.Range("Print_Area").Offset(0).Resize(.Range("Print_Area").Rows.Count + 1, _
...
7. ## Thread: VBA move print area down 1 row from active cell

by willow1985
Replies
7
Views
126

### Re: VBA move print area down 1 row from active cell

My mistake, the selected cell actually ends up just below the page break line so this code actually moves it one row lower than required. How could I adjust this code that it is even with the...
8. ## Thread: VBA move print area down 1 row from active cell

by willow1985
Replies
7
Views
126

### VBA move print area down 1 row from active cell

Hello,

I was just wondering what would be the code to adjust a print area down 1 row without using specific ranges?

I currently have a macro that finds the end of a table and adds a row for new...
9. ## Thread: Drop down box value to trigger macro

by willow1985
Replies
5
Views
149

### Re: Drop down box value to trigger macro

Works perfectly, thank you so much! :)
10. ## Thread: Drop down box value to trigger macro

by willow1985
Replies
5
Views
149

### Drop down box value to trigger macro

I have drop down lists in column O where you can toggle the status from "blank", to "open" to "closed".

What I would like to do is have a certain macro run every time the status is changed in any...
11. ## Thread: VBA Run-time error '13': Type Mismatch

by willow1985
Replies
3
Views
78

### Re: VBA Run-time error '13': Type Mismatch

I think you are right. I was given the code.

I removed the last portion and changed it to the following. Appears to be working now. Thank you very much :)

Dim lo As ListObject
For Each...
12. ## Thread: VBA Run-time error '13': Type Mismatch

by willow1985
Replies
3
Views
78

### VBA Run-time error '13': Type Mismatch

Hello, I have this code that I am not sure how it works but it appears to to a certain extent.

What I am looking to do is insert a row at the end of a table. I have other data right below the...
13. ## Thread: VBA for verifying whether a specific worksheet and cell have data or not

by willow1985
Replies
3
Views
230

### Re: VBA for verifying whether a specific worksheet and cell have data or not

Works perfect! Thank you very much! :biggrin:
14. ## Thread: Not sure if a COUNTIFS formula is the way to go

by willow1985
Replies
5
Views
124

### Re: Not sure if a COUNTIFS formula is the way to go

This appears to be working! Thank you very much :)
15. ## Thread: Not sure if a COUNTIFS formula is the way to go

by willow1985
Replies
5
Views
124

### Re: Not sure if a COUNTIFS formula is the way to go

Both of the formulas are returning a count of 0
16. ## Thread: Not sure if a COUNTIFS formula is the way to go

by willow1985
Replies
5
Views
124

### Not sure if a COUNTIFS formula is the way to go

Hello,

Can anyone help me with a formula that counts invoice dates?

Not sure if CountIF can do this or not

Basically count how many items were invoiced in the current month and then another...
17. ## Thread: #VALUE error with Sumifs formula

by willow1985
Replies
3
Views
65

### Re: #VALUE error with Sumifs formula

I must be tired. Thank you very much!
18. ## Thread: #VALUE error with Sumifs formula

by willow1985
Replies
3
Views
65

### #VALUE error with Sumifs formula

Hello,

I do not know what is wrong with the below formula - receiving a #Value error:

=SUMIFS('WO Report'!F2:F1000000, \$B\$14,'WO Report'!V2:V1000000,\$B\$12,'WO Report'!S2:S1000000)

Let me...
19. ## Thread: IF function for returning month name with data that has zeros

by willow1985
Replies
7
Views
86

### Re: IF function for returning month name with data that has zeros

Thank you guys! This is great info :)
20. ## Thread: IF function for returning month name with data that has zeros

by willow1985
Replies
7
Views
86

### Re: IF function for returning month name with data that has zeros

I figured out my error. This formula works but if anyone can let me know if there is a more efficient one that would be greatly appreciated. The data will always come in with zeros...
21. ## Thread: IF function for returning month name with data that has zeros

by willow1985
Replies
7
Views
86

### IF function for returning month name with data that has zeros

Hello,

I have a column that has a list of "0" and dates.

I am looking for a formula that will return the Month name on any cell that does not contain the text "0" and if it has a "0" return a...
22. ## Thread: Sum one column for all cells that have the previous day/current month/previous month in another column

by willow1985
Replies
5
Views
133

### Re: Sum one column for all cells that have the previous day/current month/previous month in another column

Thank you very much! :)
23. ## Thread: Modify SumIf formula

by willow1985
Replies
4
Views
158

### Re: Modify SumIf formula

Thank you all very much! :)
24. ## Thread: Modify SumIf formula

by willow1985
Replies
4
Views
158

### Modify SumIf formula

I have this SumIf formula that Sums column G if the dates in Column F Match the previous day:

=SUMIF('WorkOrder Search Export'!G2:G1000000, TODAY()-1, 'WorkOrder Search Export'!F2:F1000000)

How...
25. ## Thread: Text and Data reference formula in a text box

by willow1985
Replies
3
Views
59

### Re: Text and Data reference formula in a text box

This works. Thank you very much :)
Results 1 to 25 of 150
Page 1 of 6 1