my table contains formulas , but why in F4:F8 is showing as blank instead of zero, it should be like E4:E8 or D4:D8.
and also its not calculating, i tried to write the formula again but still im getting same issue.
thank you.
and also its not calculating, i tried to write the formula again but still im getting same issue.
thank you.
COMBINE vba .xlsm | |||||||
---|---|---|---|---|---|---|---|
B | D | E | F | ||||
3 | FEB | MAR | APR | ||||
4 | Received BGRPS | 241 | 0 | ||||
5 | Received XM | 58 | 0 | ||||
6 | Received IAT | 1 | 0 | ||||
7 | Received DAT | 0 | 0 | ||||
8 | Received BGRP | 3 | 0 | ||||
Summary |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D4 | D4 | =IF($U2<=TODAY(),COUNTIFS('raw daily'!$G$2:$G$3000,">="&$U2,'raw daily'!$G$2:$G$3000,"<="&$U3,'raw daily'!$B$2:$B$3000,$S$4),"") |
E4:E8 | E4 | =IF($V$2<=TODAY(),COUNTIFS('raw daily'!$G$2:$G$3000,">="&$V$2,'raw daily'!$G$2:$G$3000,"<="&$V$3,'raw daily'!$B$2:$B$3000,$S4),"") |
F4 | F4 | =IF($W$2<=TODAY(),COUNTIFS('raw daily'!$G$2:$G$3000,">="&$W$2,'raw daily'!$G$2:$G$3000,"<="&$W$3,'raw daily'!$B$2:$B$3000,$S4),"") |
D5 | D5 | =IF($U2<=TODAY(),COUNTIFS('raw daily'!$G$2:$G$3000,">="&$U2,'raw daily'!$G$2:$G$3000,"<="&$U3,'raw daily'!$B$2:$B$3000,$S$5),"") |
F5:F8 | F5 | =IF($W$2<=TODAY(),COUNTIFS('raw daily'!$G$2:$G$30000,">="&$W$2,'raw daily'!$G$2:$G$30000,"<="&$W$3,'raw daily'!$B$2:$B$30000,$S5),"") |
D6 | D6 | =IF($U2<=TODAY(),COUNTIFS('raw daily'!$G$2:$G$3000,">="&$U2,'raw daily'!$G$2:$G$3000,"<="&$U3,'raw daily'!$B$2:$B$3000,$S$6),"") |
D7 | D7 | =IF($U2<=TODAY(),COUNTIFS('raw daily'!$G$2:$G$3000,">="&$U2,'raw daily'!$G$2:$G$3000,"<="&$U3,'raw daily'!$B$2:$B$3000,$S$7),"") |
D8 | D8 | =IF($U2<=TODAY(),COUNTIFS('raw daily'!$G$2:$G$3000,">="&$U2,'raw daily'!$G$2:$G$3000,"<="&$U3,'raw daily'!$B$2:$B$3000,$S$8),"") |