-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
formula;
-
A
SUMPRODUCT and AVERAGE together
Hello, i am using this formula; =SUMPRODUCT(--('Jun-18'!$L:$L>=$B$2), --('Jun-18'!$L:$L<=$C$2),--('Jun-18'!$L:$L<="Open")) which returns a number of tickets closed between two date periods (dd/mm/yyyy hh:mm:ss) and works, i want to now add to this formula and of those 458 results i want to...- aiwnjoo
- Thread
- average formula; jun-18$l$l sumproduct
- Replies: 1
- Forum: Excel Questions
-
B
COUNTIFS Between 2 Dates (Works with 1 date, but not when there's 2)..
Here's the formula; =COUNTIFS('Employee Leave Tracker'!$B$4:$B$100,B8,'Employee Leave Tracker'!$C$4:$C$100,">="&$C$7,'Employee Leave Tracker'!$D$4:$D$100,"<="&$C$7) Conditions are; B8 = Name1 C7 = 30/04/2018 'Employee Leave Tracker'!B4 = Name1 'Employee Leave Tracker'!C4 = 30/04/2018 'Employee...- BenGee
- Thread
- =countifsemployee formula; leave tracker$d$4$d$100 works
- Replies: 1
- Forum: Excel Questions
-
D
Copying a formula
Here is my formula: =+Sheet1!A1 Excel is trying to do it this way: =+Sheet1!A1 =+Sheet1!A2 =+Sheet1!A3 But I would Like it to do it this way: =+Sheet1!A1 =+Sheet1!B1 =+Sheet1!C1 I would manually do it, but I have to do it through 500 Thanks DCI- DCI57
- Thread
- formula;
- Replies: 2
- Forum: Excel Questions
