Previous Topic Next Topic

How Sum the Column value in Excel via VBA based on criteria?

Solved/Closed
Raj_2823 Posts 7 Registration date Monday August 29, 2022 Status Member Last seen January 13, 2023 - Oct 3, 2022 at 06:16 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 10, 2022 at 12:01 PM

Hello All,

I would like to sum up the column value based on the following criteria (TRUE or FALSE). I have a value in the "E" column and in the "F" column having criteria (TRUE or FALSE). I have to sum the "TRUE" value in the Billable column and the "FALSE" value in the Non-billable column.

The screenshot is given below for reference.

Thanks in advance!

Regards,

Raj

Related:

2 responses

Answer 1 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Updated on Oct 10, 2022 at 12:03 PM

Wanted to add the following:

To count the actual values for TRUE and FALSE, use these array formula's:
=SUM((E5:E17)*(F5:F17=FALSE))
=SUM((E5:E17)*(F5:F17=TRUE))
NOTE: Array formula's need to be confirmed by hitting Ctrl+Shift+Enter instead of just Enter.
3
Answer 2 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Oct 4, 2022 at 11:50 AM

Hi Raj,

You are looking for the COUNTIF function.

=COUNTIF(F5:F17,FALSE)

Best regards,
Trowa
2

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How do I change a base location on Instagram?
rebelkids -
38nancy -

8 responses
Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Excel - IF function with multiple words
Nick -
user -

14 responses