# Calculating data based on Today date

#### syud_zack

##### New Member
hi all,

i'm new in Excel macro..

i'm facing the problem on calculating sum based on today date..

currently, i'm using this formula and it didn't work..

={SUM((Data!\$B\$5:\$B\$19696=TODAY())*(Data!\$C\$5:\$C\$19696=1)*(Data!\$E\$5:\$E\$19696=4))}

can any tell me, where's i'm wrong??

### Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Hi and Welcome to the Board
Have a look at SUMIF and COUNTIF instead of SUM
Maybe something like
Code:
``=SUMIF(DATA!\$B\$5:\$B\$19696,TODAY())*SUMIF(DATA!\$C\$5:\$C\$19696,"1")*SUMIF(DATA!\$E\$5:\$E\$19696,"4")``

Last edited:
i've tried SUMIF and COUNTIF before. but it keeps give me 0 for the calculation..

i don't know where i'm wrong

Probably because the first part of your SUM is trying to sum the date.
Should you maybe be trying to COUNT the number of occurrences of Today ()

Very Satisfied 0
Fairly Satisfied 0
Neither satisfied 0
Fairly dissatisfied 0
Very dissatisfied 0
Total 0

i want to be able to calculate number of response based on those criteria. the raw data is on he other sheet name Data. it always give the wrong answer. i've try count as u mentioned, it give me wrong answer

=COUNT((Data!\$B\$5:\$B\$19696=TODAY())*(Data!\$C\$5:\$C\$19696=1))

Ok, I'd suggest you post a small sample of your sheet with an expected result.
Also, Have a look at my previous posts regarding COUNTIF.....not COUNT
and SUMIF.....not SUM

Replies
4
Views
217
Replies
10
Views
337
Replies
2
Views
268
Replies
2
Views
173
Replies
2
Views
310

1,217,482
Messages
6,136,910
Members
450,030
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back