Calculating data based on Today date

syud_zack

New Member
Joined
Aug 4, 2010
Messages
3
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:
Upvote 0
i've tried SUMIF and COUNTIF before. but it keeps give me 0 for the calculation..

i don't know where i'm wrong
 
Upvote 0
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 ()
 
Upvote 0
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))
 
Upvote 0
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
 
Upvote 0

Forum statistics

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

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top