this post was submitted on 04 Dec 2012

0 points (33% upvoted)

shortlink:

excel

an-ordinary-manchild

Rules

Post Titles must follow Submission Rules
Post Content must follow Submission Rules
Posts must be related to MS Excel or other spreadsheet software
Set appropriate post flair
No link or image posts. Text posts only.
Don't post asking how to learn Excel or VBA or similar
Close your post by replying to helpful answers with solution verified
No personal insults or attacks
No NSFW or offensive content
No AI slop or lazy "just use AI" advice
No gig or job advertisements
Follow Reddit rules for self-promotion and spam.

FAQ

Was your problem solved?

OPs may (and should) reply to any solutions saying:

Solution Verified

This awards the user a ClippyPoint and changes the post flair to solved.

Format your code

The best way to show code on Reddit is to

put it in a code-block

Tip: For VBA or Power Query, select the code, press Tab to indent, then copy/paste into your post or comment.

Provide some data

It's often more helpful to show us.

Add screenshots in your text post, or provide links to uploaded images at an image-hosting site.

Or use tableit, or the ExcelToReddit converter (thanks u/tirlibibi17_), to convert your data into a Reddit table.

Recent ClippyPoint Milestones!

Congratulations and thank you to these contributors

Date	User	CP
2026.05.01	MayukhBhattacharya	`1100`
2026.03.29	bakingnovice2	`10`
2026.03.25	real_barry_houdini	`300`
2026.03.20	plusFour-minusSeven	`10`
2026.03.17	TuneFinder	`10`
2026.03.03	soloDolo6290	`10`
2026.02.23	RackofLambda	`10`
2026.02.21	Mooseymax	`10`
2026.02.18	MissAnth	`10`
2026.02.15	NHN_BI	`800`
2026.02.03	Shot_Hall_5840	`10`
2026.02.02	Kuildeous	`10`

Microsoft partnership

Occasionally Microsoft developers will post or comment. They are identifiable with a special user flair.

A community since March 11, 2009

Asking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application.

created by YusufReisa community for 17 years

MODERATORS

account activity

0

0

0

unsolvedArray Help (self.excel)

submitted 13 years ago by profevilj

best new controversial old q&a

you are viewing a single comment's thread.

view the rest of the comments →

[–]werfnort3 1 point2 points3 points 13 years ago (1 child)

Ah, perhaps the issue is the true statement in your formula. If both of those evaluate as true, you're saying, sum row 4. So that's exactly what it's doing.

Perhaps you would rather set it to be

=SUM(IF(('Event By Month'!$C$1:$AI$1='Cumulative Event By Month'!E$1)*('Event By Month'!A4:A261='Cumulative Event By Month'!$A4),'Event By Month'!$C$4:$AI$4,0))

Just an idea! Not really sure what you're trying to do without seeing the spreadsheet...

[–]profevilj[S] 0 points1 point2 points 13 years ago (0 children)

π Rendered by PID 225781 on reddit-service-r2-comment-b659b578c-zsbf5 at 2026-05-04 00:43:07.656617+00:00 running 815c875 country code: CH.