Home » Forums » Open Source Learning Center » Question and Answer

How to compare and add a count - make summary

Submitted by sajithbpillai on 10 September, 2015 - 13:41

3 columns
Sheet 1
Appointment Date - Column D row 2 (data validated list)
Sale Made (Y/N - Data Validated list) - Column E row 2
Sheet 2
Summary - Column F row 2

How to add a formula in Summary Column F Row 2 such that

If date = 10/09/2015 (for ex:) and the value in colum E row 2 is Y then add 1 in Summary Column F row 2.

‹ worksheet change with if criteria VBA!!!!!!!!!! Conditional formatting to highlight due dates only considering business days ›
»