指导我关于比较单元格包含日期和其他单元格包含下拉列表的值 [英] Guide me Regarding Compare the Value of Cell contain date and other cell contain Drop down list

问题描述

每个人，我都需要Excel公式的帮助，我有两张纸，用于销售跟踪器的sheet1，用于目标跟踪器的第二页，我使用Now()自动输入日期，并且可以正常工作，目标表中的下一步"，我使用= Sumif()计算各种类别的总数，并在单元格中引用它们.它也工作正常.但是我想根据月份和类别跟踪记录.就像我有6个类别的详细信息如下所示， 销售跟踪器

在第一张图片中，列日期由公式"= IF(ISBLANK(B5)，"-，TODAY())"组成，并且显示月份名称，例如十月"

在第二张图片中，有一个月份"列的下拉列表.

1-我想使用if语句，例如= if(Date = Month，Sum(Revenue Secure column Data)，-")但我在这里写的公式不起作用是一个示例....

2-我想要从第二张纸中选择任何一个月份(如一月，二月)时，它应该从picutre一个数据计算总和，而仅显示一月等的总和.

请帮助我，这真是让我的大脑大吃一惊，

提前谢谢....

简而言之，我的问题是如何使用If语句比较包含公式的单元格和包含下拉列表的其他单元格的值?

解决方案

我相信您必须比较月份而不是整个日期.

您可以执行TEXT(NOW();"mmmm")获取当前数据的完整月份名称(使用excel语言)，然后将其与下拉列表进行比较. 如果将NOW()替换为任何数据，它也可以正常工作.

Hy Every One, I need help in excel formula, I have two sheets, sheet1 for sale tracker, sheet two for goals tracker, I used Now() to enter date automatically, and its working fine, Next in goal sheet, I use =Sumif() to calcualte various category totals and refer them in cell. Its also working fine. But I want to track record according to month and category. Like I have 6 categories detail is as under, Sales Tracker

In the First picture Column Date consist of formula "=IF(ISBLANK(B5),"-",TODAY())" and it display the name of month like "October"

While in second picture there is a drop down list of "Month" Column.

1- I want to use if statement like =if(Date=Month, Sum(Revenue Secure column Data), "-") But its not working the formula I wrote here is an example....

2- I want when I select any month from second sheet like January, February, It should calculate sum from picutre one data and only show the sum of january etc.

Please help me, this is eating my brain a huge,,,,,,:)

Thanks in advance....

In short my question is how can I use If statement to compare value of cell that contain formula and other that contain drop down list?

解决方案

I Believe you have to compare the month and not the whole date.

You can do TEXT(NOW();"mmmm") to get the full month name of the current data (in the language of excel) and then compare it to your drop down. If you replace the NOW() with any data it works as well.

这篇关于指导我关于比较单元格包含日期和其他单元格包含下拉列表的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！